Help Needed With Failed VLOOKUP including MATCH formula

Occasional Visitor

I'm looking to search my 2nd sheet for the code stated in column B and return the information for that code in the column that matches the header. I don't want to count which column number it is, I want to find the information with the column header.

 

My formula in C2 is  =VLOOKUP(B2,OW!A:Z,MATCH(C1,OW!A:Z,0),0)

 

However, it returns #N/A but this information is definitely on the second sheet.

 

I think the issue is with my MATCH formula as when I remove this and put a number in, it pulls through the information.

1 Reply

@MMatharu 

MATCH() doesn't work on 2D ranges, it shall be single row r column.