Thread: Vlookup Table Help
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Vlookup Table Help
Think all that's needed is to make it search for an exact match:
=VLOOKUP(A2,'AIRPORT CODES'!$A$2:$B$2989,2,0)
(use 0 as the 4th param, instead of 1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply With QuoteReply With Quote