Forum Discussion
Solved
Shorter way or shortcut to use IF, AND, AND drawing from 3 variables
I have a scoresheet spreadsheet I've developed. I have 12 players playing 5 courses and each course you could be playing FRONT or BACK. Each player has a unique number associated with their name, the...
- 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.
As variant
=LET(
pos, XMATCH(G3,A:A),
names, INDEX(B:B, pos+1):INDEX(B:B, pos+12),
front, INDEX(D:D, pos+1):INDEX(D:D, pos+12),
back, INDEX(E:E, pos+1):INDEX(E:E, pos+12),
XLOOKUP(B3,names, CHOOSE( (D3="FRONT")+1, back, front) )
)Hmmm... let me see if I can handle this. Be back to you.