Matching a number in a column and returning a value from another column

It will help if you can post a small sample file (not image) with some example results.

To upload file Click "Go Advanced" then "Mage attachments"

Thank you John!

I've attached a simpler, shorter version of what I need to do.

Sheet 1 contains employee data, Sheet 2 contains the data that needs to be referenced on the Premiums column on sheet 1, depending on age.

I think I could make it simpler for ages over 64 to simply write them up until, say, 70, so we could have definite numbers to work with. But I guess this file will give you a better idea.

Thanks again John!

in F2

=VLOOKUP(DATEDIF($D2,TODAY(),"y"),Sheet2!$A$3:$C$48,2,1)

in G2

=VLOOKUP(DATEDIF($D2,TODAY(),"y"),Sheet2!$A$3:$C$48,3,1)

Copy down

This worked wonders.

Thanks for the help!!

Now, I also want to learn. Do you mind explaining those formulas? I want to understand what you did there and how I can use formulas like these in the future.

Thank you so much, John!

=VLOOKUP(DATEDIF($D2,TODAY(),"y"),Sheet2!$A$3:$C$48,2,1)

DATEDIF takes the difference between TODAY() and Birth Date and returns the number of years (the "y" parameter)

VLOOKUP uses this value i.e. age and matches this against the range A3:C48 on Sheet2. The lookup value (age) is always matched against the first column (A) in the stated range.

The 2 is the column number from which to return the required value which column B for F2 and 3 for G2 i.e. column C.

Finally the 1 tells VLOOKUP that the table is in ascending sequence (of A).

See the description of VLOOKUP in the Excel "Help on this function" when you click the function (fx) button.

Thank you John for your patience!

I'll keep inquiring about that function since I believe it'll be instrumental in upcoming projects.

Thanks again