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" wrote:

Maybe something like this:

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

--
Biff
Microsoft Excel MVP


"kattay" wrote in message
...
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