What happens if there are more than 1 of an age?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Antony Peter" wrote in message
...
version i use is Excel 2002

Name of file1 is : Workbook1
Name of file2 is: Work book2

Workbook1 - contains two fields (Age & Name)
Age Name
21 tom
22 peter
23 harry

Workbook2 - also contains two fields (Age & Name)

when i enter the age in workbook2 in cell(a1), i need to get the name of
concerned person in cell b1.

For this i have put this formula in workbook2 in cell b1
=if(a1=[Workbook1]
a1,b1, if(a1=[workbook1]a2,b2, if(a1=[workbook1]a3,b3)))
And this worked.

I have just given an example above. The actual data which i have is a big
one. So the above formula is a very complex for me to use.

IS THERE ANY OTHER FORMULA WHICH I COULD USE?