Index/Match Function

Carlos Yanes

Hey all -

Needing some help with using this formula, I can't seem to understand/figure it out when trying to look up values. Here is what I have - (sheet 1)

I'm trying to look up the values under 'Function' and bring back the result from a different sheet (shown below) - (sheet 2)

So in this case, the value 'N' should come back to the first sheet (screenshot).

Thank you!

Bassam Khalil

Hi @Carlos Yanes

Hope you are fine, please try the following formula:

=INDEX({Sheet 2}, MATCH(Function@row, {Function 2}), 2)

{Sheet 2} is the range of data in sheet 2 ( select the whole columns )

{Function 2} is the range of data in sheet 2 ( select the whole column of Function )

Bassam Khalil

Hi @Carlos Yanes

Hope you are fine, please try the following formula:

=INDEX({Sheet 2}, MATCH(Function@row, {Function 2}), 2)

{Sheet 2} is the range of data in sheet 2 ( select the whole columns )

{Function 2} is the range of data in sheet 2 ( select the whole column of Function )