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...
KC_86 , you don't need double dash here since event code is the text in both sheets. Previous time you have numbers in one sheet and texts as numbers in another one.
=INDEX(EVENT!F:F,MATCH($E2,EVENT!E:E,0))
SergeiBaklan
Thank you very much for your help again. Now it all made sense. I just tested the expression and it worked beautifully.