Last answered:

21 May 2023

Posted on:

07 Jan 2023

0

Can you combine Match and Indirect (for selecting the lookup array) in the same function?

I tried combining match and indirect in the same function for the JAN column in the task exercise but I got a #REF! error. Is this combination possible?

Here is my function =VLOOKUP($B21,INDIRECT(C20),MATCH($C5,$B$5:$N$5,0),FALSE) with the Indirect(C20) referring to a named cell range for Jan from the original company X table

1 answers ( 0 marked as helpful)
Instructor
Posted on:

21 May 2023

0

Hi Misan!

Thanks for reaching out.


Please excuse us for the belated answer.

Can you please share the file with us so that we can look into it in detail? Having the file at hand at our end will help us be precise in our answer.


Looking forward to your answer.
Best,
Martin

Submit an answer