Let's say your lookup table in A2:B4, and your lookup criteria in D2:D4

In E2 =INDEX($B$2:$B$4,MATCH(--MID(D2,FIND("1",D2),3),$A$2:$A$4,0))
Copy down


"traima" wrote:

Hei,

I am an Excel 2003-user, and I have a small problem..

I have different recievers (in text format), with and identification number
at different positions for many of the recievers, ex:

Reciever:
Reciever111 AA
Reciever122 AA
Reciever111 AB

I would like to match this list with a different list on this format:

Reciever: Latest Delivery Time:
111 12:00
122 11:30
133 11:30

I know the hlookup/vlookup-function, but there's something missing when the
identificators are different.

Any suggestions?

Thanks!