Finding current lifetime age

[Corinne]

I need to find the expected lifetime of a person at a current age based on gender. If the person is male and 72 I need the expected lifetime which is 84.4, if the person is female and 85 then I need the cell to be populated with the correct expected lifetime number of 91.8.
How do I do this? Also I have the ages updated each day the worksheet is opened based on their date of birth using this forumla in the orginal worksheet =ROUND(DATEDIF(L3,M3,"m")/12,0)

PLease help!

[benishiryo]

hi Corinne, welcome to the forum. i suppose in C2:
=VLOOKUP(A2,$G$6:$I$33,IF(B2="M",2,3),0)

[Dave Breda]

Hey Corinne,

Expected Lifetime.xlsx
Here you go, hope it will work for you!

Dave Breda

[Corinne]

Thank you!!! Both worked perfectly!! Thank you again!