VLOOKUP error
I want the city to turn up automatically when I enter the ICAO code on the excel sheet.
But many of the entries are being picked up wrongly.
Eg: VIJP is picking Jodhpur instead of Jaipur
VOBG is not picking Bangalore
It's not workin even after sorting them as per alphabetical order.
Pls help
Change the formula to:
=VLOOKUP(A3,E1:F151,2,FALSE)
AND remove the trailing spaces from the codes.
use TRIM and then Copy and Paste Spacial | Values over the original
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks