Want to display value in chart

  • Thread starter Thread starter spence
  • Start date Start date
S

spence

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
 
Back
Top