I am trying to perform a MATCH operation and getting #NA, I have checked the data type they aren't text and there is no extra space or unrecognizable characters as well. Please check the attached file.
I am trying to perform a MATCH operation and getting #NA, I have checked the data type they aren't text and there is no extra space or unrecognizable characters as well. Please check the attached file.
Last edited by excelguyb; 04-20-2021 at 03:51 AM.
I think this is what you want ..
=INDEX(Data!$B$2:$B$10,MATCH(A2,Data!$A$2:$A$10,0))
or
=VLOOKUP(A2,Data!$A$2:$B$10,2)
Please try entering MATCH formula, it is returning #NA, this is the file I am working on.
=IFERROR(INDEX('INDEX MATCH Master Emp List'!B:B,MATCH('INDEX MATCH Functions'!B3,'INDEX MATCH Master Emp List'!A:A,0)),"")
There is no match for 1054.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Can you check the VLOOKUP tab, I am confused about where am I going wrong? there is an Index and Match as well, kindly see the Index Match tab as well.
=IFERROR(VLOOKUP($B3,'Master Emp List'!$A$2:$I$38,2,0),"")
Change 2 to 3 to reference column C (4 for D and 9 for I)
Last edited by JohnTopley; 04-20-2021 at 05:03 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks