Need lookup of data both vertical and horizontal
 

Hi,

I am trying to summarise data on 2 axes:
Name: John Fred Michael
Date:

01/01/00 L
01/02/00 L

I need a formula / pivot table to search all the data, and where the letter
'L' appears, return the relevant name and date from the column and row
headers.

Any ideas on which approach and how to format the data? I'd be grateful :-)

Thanks

Need lookup of data both vertical and horizontal
 

"rmargh" wrote in message
...
Hi,

I am trying to summarise data on 2 axes:
Name: John Fred Michael
Date:

01/01/00 L
01/02/00 L

I need a formula / pivot table to search all the data, and where the
letter
'L' appears, return the relevant name and date from the column and row
headers.

Any ideas on which approach and how to format the data? I'd be grateful
:-)

Thanks

Have a look here for an explanation of how to use MATCH inside an OFFSET
formula.
http://www.cpearson.com/excel/lookups.htm#LeftLookup
This would get the name for you.
Putting the MATCH as the third parameter of the OFFSET rather than the
second would get the name.

Need lookup of data both vertical and horizontal
 

Cheers Stephen :-)

"Stephen" wrote:

"rmargh" wrote in message
...
Hi,

I am trying to summarise data on 2 axes:
Name: John Fred Michael
Date:

01/01/00 L
01/02/00 L

I need a formula / pivot table to search all the data, and where the
letter
'L' appears, return the relevant name and date from the column and row
headers.

Any ideas on which approach and how to format the data? I'd be grateful
:-)

Thanks

Have a look here for an explanation of how to use MATCH inside an OFFSET
formula.
http://www.cpearson.com/excel/lookups.htm#LeftLookup
This would get the name for you.
Putting the MATCH as the third parameter of the OFFSET rather than the
second would get the name.