Posted to microsoft.public.excel.misc
|
|
how do i use VLOOKUP to find text and return a number?
thanks for your help. but it's still only coming up with the last postcode.
"mr_teacher" wrote:
If you add an extra column in C then in C3 (or whichever row has the
first postcode in) use the formula =A3 and copy this down the column as
far as needed.
Then you can use your formula with a slight change
=IF(B5<"",VLOOKUP(B5,data!$b$3:$f$1002,2))
You will also need to change your other formula slightly to allow for
the added column
=IF(B10="","",VLOOKUP(B10,data!$A$3:$f$1002,2))
Hope this helps
Regards
Carl
roza_j2002 Wrote:
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))
--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=570584
|