Forum Discussion
Problem with If statement with text across tables
I am coming over from Tabluea, and am stuck on an If Statement - I have a transaction table "Sheet1" with a unique customer id for each transaction that has a "market sector description" with one of ...
v-easonf-msft
Community Support
Community SupportHi, Anonymous
Not sure about your needs, please share sample data and your expected results.
You can try the lookupvalue function to create calculated columns.
Best Regards,
Community Support Team _ Eason