Would like to use a vlookup.
Reference a cell for an employees age, then test that age to see what age
band it is within. Once it's determined, return a rate that is found in a
different column containing applicable rates for the age band. Not sure if I
need two columns to establish an age range or if I can do that within the
same cell (ie: col z = 25, col aa = 30 to establish an age range of 25-30 or
if I could do that in one cell with the text: 25-30)

Basically... If a person is age 25-29, return the rate of insurance.
Col A = Age Band (or perhpas split top and bottom of range into two
different col's?)
Col B = Rate of insurance for that age band

Many thanks for any help.