Reading data from another sheet where data is in variable cells

[Guest]

Hi,

I am looking for a way to create a sheet (which I'll call A) to read data
from another sheet (which I'll call B).

The data in B is team scores. What I need to do is record on sheet A the
results from the teams in B. The scores on sheet B are not in team order (for
example, the results for team 1 are in column AA but on rows 1, 6, 8, 20 and
so on). Is there a formula that I can use to read the data for each team and
present an average score on sheet A with one column for team name and one
column for average score?

I'd be grateful for some help. Oh, and a Happy New Year to you all!

 

[Bernard Liengme]

Without a total layout description it is hard to give an exact answer
You can get data from a table with VLOOKUP
You can get data from another sheet with references in the form Sheet2!A1 or
'Sheet Five'!A1 when the sheet name has a space in it.
Try to combine these
Or tell us the exact data layout
best wishes

 

[Guest]

Thanks for this. Created a pivot table and it works just fine. !