Worked with the first formule.

Thanks a lot!

"Dave Peterson" wrote:

=vlookup(int(a1/100),yourtable,2,false)
If those values are numbers.

=vlookup(left(a1,8),yourtable,2,false)
if the values are text.


Sara Gilbert wrote:

I am trying to create a lookup where I am entering a 10 account number digit
but my database only has 8 number digits. I want my lookup to ignore the
last two digit I enter and give me the corresponding 8 digit number

--

Dave Peterson