I usually use =VLOOKUP(J2,Sheet2!$B$1:$C$703,2,FALSE) (false for exact matches) but I think Hemesh's observation is exactly what is missing, I added false and it appears to be returning the values you want.
I usually use =VLOOKUP(J2,Sheet2!$B$1:$C$703,2,FALSE) (false for exact matches) but I think Hemesh's observation is exactly what is missing, I added false and it appears to be returning the values you want.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks