Hello!
I'm attempting to use INDEX(MATCH, MATCH) to populate columns G and I in tab table1, below,
Attachment 640965
with data from tab table2, below. My formula is returning #N/A.
Attachment 640966
I think the problem is my second MATCH lookup_value is arranged in a column. It's my first time doing it this way. I usually use INDEX(MATCH, MATCH) with MATCH lookup_values arranged in row and column, respectively.![]()
Please Login or Register to view this content.
Is this not the correct way to do it? Or is the problem different?
Thank you!
Bookmarks