I have a spreadsheet with cells containing the age of a person. What I want to do is specify which age range that person falls into.

For example:

Bill Smith 34 I would like a formula that says he is between 30 - 39.
Jane Doe 22 I would like a formula that says she is between 20 - 29

I don't want to have to do a separate formula for each of the 300+ entries.

I have a separate table with the age ranges in and have tried to work it out with VLOOKUP and nested IF but I cant seem to get it to work!

Help would be very appreciated.

Thanks