Column B has specific words in it (ie Tools, Cookbook, PO)
Column C has a % in it (ie 50%, 100%, 75%)
Column D-J have number in them (ie 24.3, 62, 2.50)

I have about 90 rows of this data

I'm trying to create a table underneath this list that will have the
following rows:

Tools
Cookbook
PO

What I'd like the formula to do is say if Col B = Tools then take Col C %
and * by Col D. if Col B = Cookbook then take Col C % and * by Col D. etc.


Can anyone help?