Thread: how do i use VLOOKUP to find text and return a number?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
roza_j2002 roza_j2002 is offline
external usenet poster
  
Posts: 1
Default how do i use VLOOKUP to find text and return a number?
i'm actually trying to make a postcode search. Entering the postcode, it
comes up with the suburb name fine.
But when i know the suburb name, but want to find the postcode, the only
thing i get is #N/A ... Here is the string (used for both)

COLUMN A is the postcodes
COLUMN B is the suburbs
*The one that works* =IF(B10="","",VLOOKUP(B10,data!$A$3:$E$1002,2))
*The one that doesnt* =IF(B5<"",VLOOKUP(B5,data!$A$3:$E$1002,1))

Reply With QuoteReply With Quote