formula for matching data

[san111]

I am trying to create a formula that matches the age of a customer with a list of data consisting of ages and numbers.
For example if my customer's age is 50 and on my list of data for the age 50 it has number: 0.125, I would like to use that number in a column. Please help.

 

[Juan Pablo González]

Hi, welcome to the board. You need to use the VLOOKUP formula, it consists of 4 parameters. THe first, is the value you're looking for (50), second one, is the range (or table) in wich you want to look this value, the third is which column to return from, and the fourth specifies weather you want an exact match (Set it to FALSE) or the closest match (TRUE)