Hi, Jack. No, vlookup WILL let you use a range. Just create your table like
this:
35 5%
45 6%
55 8%
etc....
Do NOT use the 4th argument for your vlookup (which is normally done when
you are looking up text values). Just =vlookup(A1,mylookup,2)
See:
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"jackoat" wrote in
message ...

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