Lookup or ?

  • Thread starter Thread starter Dean
  • Start date Start date
D

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
 
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)
 
Back
Top