Jul 13 2021 09:15 AM
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.
Jul 13 2021 12:43 PM
MATCH() doesn't work on 2D ranges, it shall be single row r column.