Looking up a multiple choice answer?

[sobeitjedi]

Hi.

On sheet2, I have a load of questions & answers from a survey. Row 90, Columns D and E contain Yes and No respectively as the answer options, with a tickbox in each cell, one of which is ticked for each question.

On sheet1, I want to enter in cell b2 a formula which will return the result (yes or no) depending upon which was ticked in D90 or E90.

How do I do this? What is the correct formula?

 

[jjasmith4]

If these two "tickboxes" are option controls, you have to look at what their LinkedCell property is, then write a formula like:
=IF(YesLinkedCell=0,"No,"Yes")

 

[sobeitjedi]

Thanks for the reply, the plot thickens....

I have now found the linked cells, but for each question where Yes or No has been ticked, the linked cell property could be True or False (sometimes No is ticked and = True, sometimes No=False). All I want to know is which tick box has been ticked, but how?

 

[sobeitjedi]

Anyone? Please help!

 

[jjasmith4]

Is it possible that both Yes and No are checked, or that neither Yes nor No is checked? If not (which should be the case), then either Yes's linked cell is True or No's linked cell is True, never both.