How to i replicate a ProductIF function where i multiply values based on criteria vs adding them?

cnfidelis
cnfidelis used Ask the Experts™
on
Is there an Excel ProductIF function?  
I basically want to reproduce a SumIf function whereby a value in a column corresponds to a value in a range to multiply against another column across from it containing a value .. in this case, i want to lookup a value in .. i've attached a screen shot of a simplified table which produces my answer in Column D.. BUT obviously, i want to change the value of range B11:B15 and have it refer to the matching % values in range C2:C8.  

I'm interested in dynamic what-if values in Column D.  
thanks!
cn
ProductIF.PNG
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Analyst Assistant
Commented:
Try this in D11 and copy down.

=C11*INDEX($C$2:$C$8,MATCH(B11,$B$2:$B$8,0))

Author

Commented:
Norie, well what great and timely service.. i knew it prob was an INDEX function but i guessed rightly that an expert would cut to the quick and hand it over..  guess i need to brush up on these more..

thanks a bunch!  
cn

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial