| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup partial text from a single cell
I use a spread sheet which includes the customer address (city and state) in
a single (merged) cell. The spreadsheet also containes a look up table with 2-letter state abbreveations. I need to capture only the state from the address (cell E5) for the vlookup. =IF(VLOOKUP(E5,$GC$9:$GD$59,2,FALSE)=0,"NO",IF(VLO OKUP(E5,$GC$9:$GD$59,2,FALSE)0,"Yes")) Excel 2003 SP1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to diffrentiate Text & number from a single cell???? | New Users to Excel | |||
| Cell Capacity - text | Excel Discussion (Misc queries) | |||
| Formula to transfer text from merged cells to single cell? | Excel Discussion (Misc queries) | |||
| Finding Partial Text in a Cell | Excel Worksheet Functions | |||
| Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
