View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SamB SamB is offline
external usenet poster
 
Posts: 10
Default 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?