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!
|