What I attend to do is compare the last 6 digits

The last 6 characters would be RIGHT($I17,6)

if match return the corresponding value in column 2.
Then I'd think you could reduce the lookup range to just $A:$B, but i doubt
that would make any significant impact.

HTH,

"Cam" wrote in message
...
Hello,

I got two sheets on the same file. Sheet1 has column with numeric/ general
data with 3 leading zero in the beginning, ex: 000123456.
Sheet2 is a template with column same data except only six digits 123456.
I
did a Vlookup to compare this column and output the other column.
My formula is:
=VLOOKUP(RIGHT($I17,3),Data!$A:$P,2, FALSE)

But it is not outputing the data instead shown "#N/A".
What I attend to do is compare the last 6 digits, if match return the
corresponding value in column 2. Thanks