If cell equals a name then get data from column

[JDB]

I need to pull data from monthly spreadsheets that is a list of names and
results. The names are not always in the same order. I need to collate the
results by line manager. The list of names is not divided into line manager
teams.

I have a sheet already that lists team member by line manager. I now need to
populate the data. So I really need is if cell on data sheet = "persons name"
then show me the data in column u for that person.

Any ideas?

 

[Bam]

Is hard to tell where you want to put the data?
Next to the name listed next to the line Manager?

If so...and the data is numerical and needs to be summed???
=SUMIF(A:A,A2,B:B)

where A:A = "Persons Name" Column on Monthly Spreadsheet.
Where A2 = Persons Name. From Line Manager/ Employeee list.
Where B:B = Data for collection.

It's all about how you ask the question, so i'm not sure if this helps or not?

Bam.

 

[Gord Dibben]

Check out the VLOOKUP function examples in help.

=VLOOKUP(person's name,lookup_table,column_number,FALSE)

"person's name" can be a cell reference.


Gord Dibben MS Excel MVP