I have a list of bank branch codes
Worksheet one
Lower bound Upper Bound Name
0 6611600 Bank A
6611601 7000000 Bank B
7000001 750699 Bank C

I have a list of bank details per employee
Emp No Bank Branch code
001 0045000
002 6611609
003 750601

How do I use the employee's bank branch code to return the bank name from
the other worksheet?

Thanks
JBS