Forum Discussion

Copper Contributor

May 17, 2019

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...

Database (4).xlsx650 KB

excel

Formulas and Functions

SergeiBaklan
May 17, 2019
KC_86 , it could be

=INDEX('Data 1'!B:B,MATCH(--$C2,'Data 1'!A:A,0))

and fill it down
Database (4).xlsx669 KB

SergeiBaklan

Diamond Contributor

May 17, 2019

KC_86 , it could be

=INDEX('Data 1'!B:B,MATCH(--$C2,'Data 1'!A:A,0))

and fill it down

Database (4).xlsx669 KB

Kim_Wennerberg

Copper Contributor

May 17, 2019

Sergei,
Can you explain the double-dash used in the MATCH function? (--$C2)