Pl HELP! Excel search

i have an excel file (file1.xls) with 2 columns (first name) & (last name) and another file (file2.xls) with 3 columns (first name) , (last name) & (Age).

pl suggest a way to search the combination (first name & last name) from file1 in file2, retreive the corresponding Age from file2...and place it in file1.

no 2 combinations will be same.

THANKS in ADVANCE!

The best way (if you are not going to do this to often and it's a long list) would be to use formulas.
1) Open both of your spreadsheets.
2) In the next column of file1 add a formula to combine both fields =A1&" " &B1 (I'm assuming that A1 is the name and B1 the surname) Copy this through to the bottom of your list
3) Add another column between your surname and age in file2 and combine the name and surname as you did in 2 for that column. Copy through to bottom of your list.
4) Use the vlookup function on file1 to find the age in file 2 (best is to use wizard. =VLOOKUP(C1,[Book3]Sheet1!$C:$D,2,FALSE) Copy through to end of text
5) Remember to copy and paste special (values) your text afterwards!


If you want a macro to do this, it's going to be more complicated. Let me know and I'll give you some pointers.