Vlookup and ranges

[JBS]

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

 

[Bernie Deitrick]

JBS,

With code in cell B2,

=VLOOKUP($B2,'Sheet with Bank Names'!$A$2:$C$XXXX,3)

where XXXX is the row of the las entry in your data table.
Assumes that the data table is sorted by lower bound, with lower bound in column A and Bank ID in
column C.

HTH,
Bernie
MS Excel MVP