List of Variables to Determine a Result

I have attached a sample workbook with my data.

I have a series of rate tables - as of now 7 columns D-J. Rows 9 - 13 have variables that are different for each rate plan. I have created in column A a drop down list to input what option our customer has chosen - Yes or No for Product F - Product J.

I am seeking a formula that will look at the fields A9 - A13 and based on the results tell me which rate plan D3 - J3 is the one that meets the criteria.

Thanks

Trying to get this formula to work....

=IF(AND($A$12="Yes",$A$13="Yes",$A$14="Yes",$A$15="Yes",$A$16="Yes"),"Plan2.3")=IF(AND($A$12="Yes",$A$13="Yes",$A$14="No",$A$15="Yes",$A$16="No"),"Plan2.4")=IF(AND($A$12="Yes",$A$13="Yes",$A$14="No",$A$15="Yes",$A$16="Yes"),"Plan2.5")=IF(AND($A$12="Yes",$A$13="Yes",$A$14="Yes",$A$15="No",$A$16="No"),"Plan2.6")

RFL3001 said:

I have attached a sample workbook with my data.

Click to expand...

No you haven't.

Sample Workbook

I have attached the workbook.

You can see how I have the formula working in separate cells. I want the result to be in one cell. By selecting the various Yes/No it will tell me which is the plan the user should be on.

Thx

I have added the workbook with some comments.

Thank you very much for any assistance.

Best thing would be to set up a lookup table, then reference that in your formula.

any cell in any column BUT columns B:I :
=INDEX($A$3:$I$3,SUMPRODUCT((A12=C12:I12)*(A13=C13:I13)*(A14=C14:I14)*(A15=C15:I15)*(A16=C16:I16)*COLUMN(C3:I3)))