Hi

I am trying to use vlookup to pick up a value corresponding to a
particular age group. However, as far as i know, Vlookup only returns a
value based on a specific input value, rather than a range of values.

For example, if the table contains the bonus rates based on age group.

e.g. age 35 and below, rate = 5%
age 36 - 45, rate = 6%
age 46 - 55, rate = 8% etc.

I want a particular cell to return the corresponding bonus rate from
the table when the user enters his age in another cell. e.g. for age
40, it gives 6%

What can I do?

Looking forward to your help out there. Thanks!!

Jack


--
jackoat
------------------------------------------------------------------------
jackoat's Profile: http://www.excelforum.com/member.php...o&userid=25800
View this thread: http://www.excelforum.com/showthread...hreadid=392055