You need to add FALSE to the end of your formula to get an exact match unless your data is sorted.
eg =VLOOKUP(B3,$D$3:$E$6,2,FALSE)
You need to add FALSE to the end of your formula to get an exact match unless your data is sorted.
eg =VLOOKUP(B3,$D$3:$E$6,2,FALSE)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks