Hello!

I am constructing a sheet which attempts to summarise lots of data from another sheet.
I'm going to give an example of two sheets below which simplifies the problem because I'm finding it impossible to describe!

e.g.

Sheet 1 looks like this:

A --------- B --------- C

Dave------Summer-------4
Mary------Winter--------2
Tom-------Winter--------3
Dave------Winter--------2
Tom------Summer-------1


Sheet 2 summarises like this:

Name-------Winter------Summer

Dave----------2-----------4
Tom-----------3-----------1
Mary----------2-------("" / BLANK)

I can use vlookups pretty well, and have used these combined with ISNA before as well to return column 'x' from a data rnage on another sheet.

The problem I'm having here is I can't figure out a way to get the second sheet to check for the 'season' as well as the name of the inidividual.

Any ideas?

Many thanks in advance for any assisstance, even reading this is much appreciated!

Andrew.