vlookup

S

Sara Gilbert

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
 
A

aristotle

Hi,

Lookup value is in e.g. A1:

=VLOOKUP(LEFT(A1,8),Lookup_Table,1,0)

Where Lookup_Table is the table or array you want to return the
corresponding number from.

Regards,
A
 
D

Dave Peterson

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

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

Sara Gilbert

unfortunately gives me: #N/A


=VLOOKUP(LEFT(B13,8),Data,2)

Data is my database info on another sheet
 
S

Sara Gilbert

Worked with the first formule.

Thanks a lot!

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

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