I would like to show a value if 2 type of data is chosen

Example
Due Date Date of Billing Number
05W Sept 2009 55
06S Oct 2009 47.5
07C Sept 2009 28.12

So if 05W and Sept 2009 is shown 55 will appear.

Spence,

With 05W in H1, and Sep 2009 in H2

=IF(SUMPRODUCT((A2:A10=H1)*(B2:B10=H2)*ROW(A2:A10) )<0,INDEX(C:C,SUMPRODUCT((A2:A10=H1)*(B2:B10=H2)* ROW(A2:A10))),"Not
Found")

You may have a problem with the dates, depending on how you entered them / formatted them. The date
values must be entered exactly the same.

HTH,
Bernie
MS Excel MVP


"spence" wrote in message
...
I would like to show a value if 2 type of data is chosen

Example
Due Date Date of Billing Number
05W Sept 2009 55
06S Oct 2009 47.5
07C Sept 2009 28.12

So if 05W and Sept 2009 is shown 55 will appear.

=SUMPRODUCT((A3:A15=A19)*(B3:B15=B19)*(C3:C15))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"spence" wrote in message
...
I would like to show a value if 2 type of data is chosen

Example
Due Date Date of Billing Number
05W Sept 2009 55
06S Oct 2009 47.5
07C Sept 2009 28.12

So if 05W and Sept 2009 is shown 55 will appear.