vLookup a portion of a no. in a cell

[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

 

[T. Valko]

Maybe something like this:

=VLOOKUP(--LEFT(A2,2),Table2,2,0)

 

[kattay]

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?

 

[T. Valko]

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?

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.