Hello. I am trying to create a formula that looks for a particular question code in a specific cell (eg, A1, A2, B1, etc) and populates the question text in another cell. I thought an If(OR formula would work, but either my syntax is wrong or maybe I'm going about it the wrong way. Can someone please help? This is what I have so far...
=IF(AND(OR(E2="A1",'Mock CAHPS Adult CQs'!C2,OR(E2="A2",'Mock CAHPS Adult CQs'!C3,OR(E2="B1",'Mock CAHPS Adult CQs'!C4,OR(E2="B2",'Mock CAHPS Adult CQs'!C5,OR(E2="B3",'Mock CAHPS Adult CQs'!C6,OR(E2="B4",'Mock CAHPS Adult CQs'!C7,OR(E2="B5",'Mock CAHPS Adult CQs'!C8,OR(E2="C1",'Mock CAHPS Adult CQs'!C9),OR(E2="D1",'Mock CAHPS Adult CQs'!C10,OR(E2="D2",'Mock CAHPS Adult CQs'!C11,OR(E2="E1",'Mock CAHPS Adult CQs'!C12,ORF(E2="E2",'Mock CAHPS Adult CQs'!C13,OR(E2="E3",'Mock CAHPS Adult CQs'!C14,OR(E2="E4",'Mock CAHPS Adult CQs'!C15,OR(E2="F1",'Mock CAHPS Adult CQs'!C16,OR(E2="F2",'Mock CAHPS Adult CQs'!C17,OR(E,2="F3",'Mock CAHPS Adult CQs'!A18,OR(E2="F4",'Mock CAHPS Adult CQs'!C19,OR(E2="F5",'Mock CAHPS Adult CQs'!C20,OR(E2="F6",'Mock CAHPS Adult CQs'!C21,OR(E2="F7",'Mock CAHPS Adult CQs'!C22,OR(E2="F8",'Mock CAHPS Adult CQs'!C23,OR(E2="G1",'Mock CAHPS Adult CQs'!C24,OR(E2="G2",'Mock CAHPS Adult CQs'!C25,OR(E2="G3",'Mock CAHPS Adult CQs'!C26,OR(E2="G4",'Mock CAHPS Adult CQs'!C27,"")))))))))))))))))))))))))))
I either get an error message that I am missing an opening or closing parenthesis or I get a msg that there is a problem with the formula. It just doesn't tell me what the problem is.
Thank you in advance for any help you can provide.
=IF(AND(OR(E2="A1",'Mock CAHPS Adult CQs'!C2,OR(E2="A2",'Mock CAHPS Adult CQs'!C3,OR(E2="B1",'Mock CAHPS Adult CQs'!C4,OR(E2="B2",'Mock CAHPS Adult CQs'!C5,OR(E2="B3",'Mock CAHPS Adult CQs'!C6,OR(E2="B4",'Mock CAHPS Adult CQs'!C7,OR(E2="B5",'Mock CAHPS Adult CQs'!C8,OR(E2="C1",'Mock CAHPS Adult CQs'!C9),OR(E2="D1",'Mock CAHPS Adult CQs'!C10,OR(E2="D2",'Mock CAHPS Adult CQs'!C11,OR(E2="E1",'Mock CAHPS Adult CQs'!C12,ORF(E2="E2",'Mock CAHPS Adult CQs'!C13,OR(E2="E3",'Mock CAHPS Adult CQs'!C14,OR(E2="E4",'Mock CAHPS Adult CQs'!C15,OR(E2="F1",'Mock CAHPS Adult CQs'!C16,OR(E2="F2",'Mock CAHPS Adult CQs'!C17,OR(E,2="F3",'Mock CAHPS Adult CQs'!A18,OR(E2="F4",'Mock CAHPS Adult CQs'!C19,OR(E2="F5",'Mock CAHPS Adult CQs'!C20,OR(E2="F6",'Mock CAHPS Adult CQs'!C21,OR(E2="F7",'Mock CAHPS Adult CQs'!C22,OR(E2="F8",'Mock CAHPS Adult CQs'!C23,OR(E2="G1",'Mock CAHPS Adult CQs'!C24,OR(E2="G2",'Mock CAHPS Adult CQs'!C25,OR(E2="G3",'Mock CAHPS Adult CQs'!C26,OR(E2="G4",'Mock CAHPS Adult CQs'!C27,"")))))))))))))))))))))))))))
I either get an error message that I am missing an opening or closing parenthesis or I get a msg that there is a problem with the formula. It just doesn't tell me what the problem is.
Thank you in advance for any help you can provide.