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.