vLookup a portion of a no. in a cell

  • Thread starter Thread starter kattay
  • Start date Start date
K

kattay

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
 
Hi, thanks. It worked.
I guess the 2 in "--LEFT(A2,2)" refers to the no. of digits I want to
lookup. What about "--", does it denotes anything?
 
I guess the 2 in "--LEFT(A2,2)" refers to the no.
of digits I want to lookup
Yes

What about "--", does it denotes anything?
Click to expand...

The LEFT function is a text function and as such returns a *TEXT* value. The
double unary is one method of coercing the text result of 20 to the numeric
result of 20 so that you have matching data types between the lookup value
and the data in the lookup table.

TEXT 20 and numeric 20 aren't the same to Excel.
 
Back
Top