formula answer with vlookup

[wasim.qureshi]

Hi, please can anyone help me with the following?

sheet 1 details of five employee
empl code--- employee name,--Dobirth --- (Age result )
1 --- ricky 12-Jun-47 =+TODAY()-b3 62
2 --- lara -16-Jun-65 =+TODAY()-c3 44
3 --- adam -16-Jun-65 =+TODAY()-d3 45

with the help of vlookup when i get data from employee code in sheet 2 insist of age 62, 42and 45 i get answer some numbers so i want answer of that formula and also sum formula answer from sheet 1 to sheet 2.

Heaps of thanks in advance,
Wasim

[NBVC]

Not sure.. but maybe you want to use SUMIF.

Take a look at SUMIF help in Excel Help files.