Forum Discussion
Solved
LOOKUP Expression?
Hello, I have two sheets in an Excel document, Data 1 and Data 2. Data 1 has Columns [Participant] and [Area]. Data 2 has the same columns but the [Area] is empty. I would like to know ho...
SergeiBaklan
I tried to apply the same expression for different spreadsheets but it didn't work because of the wrong data type. Could you advise me how should I fix the error? I used your expression before and it worked on other sheets but not this one.
I want to look up the Dosage value in EVENT tab based on the Event Code columns for PARTICIPATION tab.
Thank you.