Forum Discussion
Shorter way or shortcut to use IF, AND, AND drawing from 3 variables
- I'm very impressed by this formula! I am tooling around with it to expand it to all courses and when the formula is on separate worksheets etc. But you've given me a great tool to work with! Thanks.
I suggest to add an IF statement in cell C3 that returns either F or M for female (in this example for "Gina M") or male based on the selected value in cell B3.
I adapted the named ranges e.g. "Sand Hollow" to "Sand_Hollow" according to the requirements of named ranges. Formulas in ranges C33:K33 and C34:K34 are updated accordingly and the suggested formulas are in C8 and C9 (copied across ranges C8:K8 and C9:K9) and it seems to work.
I am hitting wall on referencing =@INDEX(INDIRECT($I$3),IF($C$3="M",2,3),IF($B$5="FRONT",COLUMN(B1),COLUMN(L1))) on another worksheet. The name of this worksheet is ParHCPs. So I've tried referencing COLUMN(ParHCPs!B1) with broken results. I've been searching, but the other COLUMN formulas are treated differently, and I don't want to pollute what you've done.
The other issue is once I've attempted to use the INDEX(INDIRECT on another worksheet and trying to reference, my Lists have all gone wonky and look like this. My biggest fear is breaking everything!
