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