Thread: Contains text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
traima traima is offline
external usenet poster
 
Posts: 23
Default 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!