Hello, can you please help me with this formula ?
I would like to do a formula similar to vlookup between Unique item values (text format) of two transaction lists (check if a transaction list contains (or not) the Unique item values of the other transaction list → if Unique ID of TL1 is in TL2 then yes, otherwise no)
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/3fde7b91-f61d-4b0d-bdf2-06faec583445.png)
Is it possible to use vlookup equivalent between text format values, or do I have to create a dimension ?
Thanks in advance!