Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula non specific lookup
Hi,
I have in column C city county names I have in column E invoice numbers in column K I need to place the city name. I have sorted by invoice # in order to get every tax piece of the invoice required. City & county name. The city name and the county name are not in different columns and they can only be identified by either CO or CNTY. I'm trying to break out the columns. I now need to create a formula that will pull the city name over to column K. The problem is since the city and county are in the same column and the wording of the city county is not specific I cannot use the lookup. ex. "C" "E" "'J" "k" northport 080006 tuscaloosa CNTY need northport to show here northport 080006 tuscaloosa CNTY need northport to show here tuscaloosa cnty 080006 tuscaloosa cnty need northport to show here montgomery co 12345 montgomery co need montgomery here montgomery 12345 montgomery co need montgomery here Can you help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formating not recognised in lookup formula | Excel Discussion (Misc queries) | |||
RETURNING A SPECIFIC VALUE FROM A LOOKUP FORMULA | Excel Discussion (Misc queries) | |||
lookup formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How to create specific formula | Excel Worksheet Functions |