Finding a row/column header in Pivottable

[Guest]

Okay, this is somewhat backwards but it is a necessary evil...

I have data that goes like this:

Transaction Date Location Account Amount
10/06/2006 1 200 $300
10/06/2006 2 100 $500
10/06/2006 1 100 $100
10/07/2006 3 200 $400

and this data is in Access and brought into a pivottable in excel such as
this...
Location (Column Headings)
Transaction Date (Row Heading 1)
Account (Row Heading 2)
SumofAmount (Values)

is there a "reverse lookup function" for pivottables that would tell me the
transaction date for particular amount, account, and location?

 

[Guest]

=SUMPRODUCT(--(Location=2),--(Account=100),--(Amount=500),Transaction)

 

[Guest]

what do the "--" mean?

=SUMPRODUCT(--(Location=2),--(Account=100),--(Amount=500),Transaction)

 

[Guest]

Sorry, can you elaborate in what this "--" means for the sumproduct
function...I don't use it too often...

 

[David Biddulph]

If you Google for "double unary minus" in conjunction with Excel and
SUMPRODUCT, you'll find explanations in places such as
http://www.mcgimpsey.com/excel/variablerate1.html

 

[Guest]

thanks. I had tried but tooo much information came down.