IF function with multiple Trues, multiple outcomes

Hello All,

First off I would like to say hello. I have found this forum very useful in the past but this is my first post! I am relatively novice at excel, so I apologize for that. Thank you for all of the help you guys have provided and for the help I can hopefully get on this question. So here we go

So I have a column of different dollar values and an adjacent column that will just be Yes or No for each dollar value. Only one value will every come out as "Yes." I just want a function for a cell on a seperate sheet that shows the dollar value for whichever one is currently chosen (Says Yes).

Does this make sense? Sorry if this is a very simple question and thank you very much for any help you can provide.

Wayne,

Thank you, the index match worked perfectly. In this instance there will not ever be more than one yes. Just out of curiosity, is there a way to write it so that if there were two "Yes"s, it would sum those two values?

Again thanks for the help!