Lookup or ?

[Dean]

Hi

I have problem with lookup

Our sales iten No.s are 8 digits; ex 19108410.
When we have a new version of the same item we change it
to ex 19108411, 19108412 etc.

I want to look up the latest, probably using the Vlookup.

File1 containing 1910841x
File2 containing
Item No Price
19108410 100
19108411 103
19108412 104

Thanks in at advance,
Dean

 

[Frank Kabel]

Hi
one way:
This requieres that your file containing the item no. is sorted
ascending in rrepsect to the item no.
If A1 stores a value like 1910841 try using
=VLOOKUP(A1*10+9,'sheet2'!A1:B1000,2,1)