| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP function with embedded LEFT
I am using a VLOOKUP function to look up what State and area code is from.
The lookup value is being calculated by using a LEFT formula to pull the area code from a cell where the full phone number is located. However, the LEFT formula is adding " on each side of the area code when it calculates which leads to an error in the lookup. Is there any way around this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup combined with LEFT function | Excel Worksheet Functions | |||
| Embedded If Function in a Vlookup Function | Excel Worksheet Functions | |||
| Embedded VLOOKUP function within IF function | Excel Worksheet Functions | |||
| Vlookup and left function | Excel Discussion (Misc queries) | |||
| HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
Threaded Mode
