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