Craigc3814
Board Regular
- Joined
- Mar 7, 2016
- Messages
- 217
I have created this formula for a spreadsheet that scores your selection based off of the cell you select. (I Know its horrible). The main thing I want to fix is the worksheet reference bit of it. I would like to use the indirect formula to reference the worksheets so I can drag the formula down rather than having to do a find and replace when I want the score a different sheet. Indirect confuses the crap out of me for some reason.
=IF('1.1.2'!$C$6=$H$7,$A$1,IF('1.1.2'!$C$7=$H$7,$A$2,IF('1.1.2'!$C$8=$H$7,$A$3,IF('1.1.2'!$C$9=$H$7,$A$4,IF('1.1.2'!$C$10=$H$7,$A$5,IF('1.1.2'!$D$6=$H$7,$B$1,IF('1.1.2'!$D$7=$H$7,$B$2,IF('1.1.2'!$D$8=$H$7,$B$3,IF('1.1.2'!$D$9=$H$7,$B$4,IF('1.1.2'!$D$10=$H$7,$B$5,IF('1.1.2'!$E$6=$H$7,$C$1,IF('1.1.2'!$E$7=$H$7,$C$2,IF('1.1.2'!$E$8=$H$7,$C$3,IF('1.1.2'!$E$9=$H$7,$C$4,IF('1.1.2'!$E$10=$H$7,$C$5,IF('1.1.2'!$F$6=$H$7,$D$1,IF('1.1.2'!$F$7=$H$7,$D$2,IF('1.1.2'!$F$8=$H$7,$D$3,IF('1.1.2'!$F$9=$H$7,$D$4,IF('1.1.2'!$F$10=$H$7,$D$5,IF('1.1.2'!$G$6=$H$7,$E$1,IF('1.1.2'!$G$7=$H$7,$E$2,IF('1.1.2'!$G$8=$H$7,$E$3,IF('1.1.2'!$G$9=$H$7,$E$4,IF('1.1.2'!$G$10=$H$7,$E$5," ")))))))))))))))))))))))))
=IF('1.1.2'!$C$6=$H$7,$A$1,IF('1.1.2'!$C$7=$H$7,$A$2,IF('1.1.2'!$C$8=$H$7,$A$3,IF('1.1.2'!$C$9=$H$7,$A$4,IF('1.1.2'!$C$10=$H$7,$A$5,IF('1.1.2'!$D$6=$H$7,$B$1,IF('1.1.2'!$D$7=$H$7,$B$2,IF('1.1.2'!$D$8=$H$7,$B$3,IF('1.1.2'!$D$9=$H$7,$B$4,IF('1.1.2'!$D$10=$H$7,$B$5,IF('1.1.2'!$E$6=$H$7,$C$1,IF('1.1.2'!$E$7=$H$7,$C$2,IF('1.1.2'!$E$8=$H$7,$C$3,IF('1.1.2'!$E$9=$H$7,$C$4,IF('1.1.2'!$E$10=$H$7,$C$5,IF('1.1.2'!$F$6=$H$7,$D$1,IF('1.1.2'!$F$7=$H$7,$D$2,IF('1.1.2'!$F$8=$H$7,$D$3,IF('1.1.2'!$F$9=$H$7,$D$4,IF('1.1.2'!$F$10=$H$7,$D$5,IF('1.1.2'!$G$6=$H$7,$E$1,IF('1.1.2'!$G$7=$H$7,$E$2,IF('1.1.2'!$G$8=$H$7,$E$3,IF('1.1.2'!$G$9=$H$7,$E$4,IF('1.1.2'!$G$10=$H$7,$E$5," ")))))))))))))))))))))))))