Both of the below formulas keep returning me a #N/A
=INDEX('convert cost code table'!A1:A248,MATCH(Report1!A13,'convert cost code table'!B1:B248,0))
=VLOOKUP(A13,'convert cost code table'!B2:B500,2,TRUE)
I am tell it to look at the cell A13, go to the other sheet (convert cost code table) look through the list and when it matches, give me the answer in the column next to it.
What am I doing wrong?
numbers in A13 are set up like this 90-010-0 is using information like this that isn't really a number, an issue?