Formula for populating cell/s based on criteria

[Tizzi203040]

Hi,

I am trying to do a function in excel but i am having difficulty coming up with the formula for it. So basically what i want to do is:

Column A(Cells in this column are drop downs) Column B Column C Column D Column E
Product A $10,000
Product B $20,000
Product C $30,000

I want to be able to check a box or insert a Y(Yes) in Columns C, D or E and have it populate with the price from column B. Now, Vlookup will not work because I want to be able to select which columns should be populated with that price. I have 10+ columns so instead of typing the price over and over again I figured if there was a way to do it with a formula. Is there a way to combine formulas so that if I select Y from a drop down then that same cell will populate with the price?

 

[Tizzi203040]

Re: Need formula for populating cell/s based on criteria

so i tried the first formula and it return back the code in cell D11. I want it to return a "Y" based on table 1.

 

[DanteAmor]

Re: Need formula for populating cell/s based on criteria

so i tried the first formula and it return back the code in cell D11. I want it to return a "Y" based on table 1.

Test with the data as shown in my example.
Check the operation of the formula and then change it.