Thread: vLookup a portion of a no. in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kattay kattay is offline
external usenet poster
  
Posts: 3
Default vLookup a portion of a no. in a cell
Can I do a vlookup on the 1st 2 no. of a 6 digits no.? Eg.
Table 1
Postal Code Area
200455 ?

Table 2
Postal Code Area
20 A
I want table 1 to reflect A
Reply With QuoteReply With Quote