Nel post
*terryc* ha scritto:

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?


VLOOKUP always returns the first match.

I think for your needs is most suitable a Pivot Table.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy