Hi,
I was in the process of trying to pull data from a table using an Index, Match Formula, but for some reason, it is pulling from the incorrect results.
Based on the attached spreadsheet, I am trying to pull how many reports are worked on by Company Code Per state. The list of states is in Column A, and the company codes are in row 11. So, I thought that my formula would easily pull when it set it up like this:
=+INDEX(B12:J61,MATCH(N12,B11:J11,0),MATCH(M12,STATE,0))
However, when I go to lookup say Delaware for company 8601 it is pulling up a different state and company code.
Is there a quick fix to this?
Bookmarks