=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