Contains text
 

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!

Contains text
 

Hi Teethless mama,

It works if all receiver code starts with "1", but what if there is one
starting with "2"?
Traima should answer this question, on the other hand do you know a method
to find the first digit (0-9) in a string?

Regards,
Stefi

€žTeethless mama€� ezt Ã*rta:

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!

Contains text
 

Stefi, you are right. The reciever code can start with anything, that's my
problem..

Stefi skrev:

Hi Teethless mama,

It works if all receiver code starts with "1", but what if there is one
starting with "2"?
Traima should answer this question, on the other hand do you know a method
to find the first digit (0-9) in a string?

Regards,
Stefi

€žTeethless mama€� ezt Ã*rta:

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!