| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to find replace text or symbol with carriage return | New Users to Excel | |||
| Return a text string when the result of VLOOKUP formula is #N/A | Excel Worksheet Functions | |||
| Pivot Table (vlookup 2 column text values, return 1 value) | Excel Discussion (Misc queries) | |||
| Find certain text in a column and return statement | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Threaded Mode
