I use vlookup all the time. For whatever reason it keeps returning #N/A on every cell.
I can only suspect that the data that was provided is somehow messed up
I want to try using INDEX MATCH instead of VLOOKUP to see if I get the wanted results.
I have never use INDEX MATCH and would appreciate assistance
I need equivalent of the VLOOKUP formula below using INDEX MATCH if someone can assist
=VLOOKUP(A2,D:H,4,FALSE)
I can only suspect that the data that was provided is somehow messed up
I want to try using INDEX MATCH instead of VLOOKUP to see if I get the wanted results.
I have never use INDEX MATCH and would appreciate assistance
I need equivalent of the VLOOKUP formula below using INDEX MATCH if someone can assist
=VLOOKUP(A2,D:H,4,FALSE)