formula for matching data

san111

New Member
Joined
Sep 10, 2002
Messages
8
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.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,763
Messages
5,574,096
Members
412,567
Latest member
mm1
Top