ExcelBanter - Contains text

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Contains text (https://www.excelbanter.com/excel-worksheet-functions/120987-re-contains-text.html)

Stefi

Contains text

=VLOOKUP(MID(A2,9,3),Munka9!A2:B4,2,FALSE)

Column A Column B
Reciever
Reciever111 AA =VLOOKUP(MID(A2,9,3),Sheet2!$A$2:$B$4,2,FALSE)
Reciever122 AA
Reciever111 AB

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

Regards,
Stefi

All times are GMT +1. The time now is 11:23 PM.