I have a large table in which I have information on a number of
employees.

I want to create a smaller table on another spreadsheet that will
summarise this info. By typing in an age, for example, I want my table
to VLOOKUP employees of that age and then in the new table give names
and other info for all employees of that age.

However, when I try to do this, VLOOKUP always gives me info for the
first employee it finds in the table, so instead of getting the
following for example:

Age Name

25 Anne
25 James
25 John
25 Tom
25 Victor

I get the following:

Age Name

25 Anne
25 Anne
25 Anne
25 Anne
25 Anne

Does anyone know what I could do about this?


--
terryc
------------------------------------------------------------------------
terryc's Profile: http://www.excelforum.com/member.php...o&userid=35796
View this thread: http://www.excelforum.com/showthread...hreadid=556044