Forum Discussion
eacrusher
Dec 25, 2025Copper Contributor
Index and match mystery (for me that is...)
Hello, I am having a hard time with an Index and match function I created. It's very simple but I am overlooking something. I am creating a file in which I can keep track of my golf progress. ...
SergeiBaklan
Dec 27, 2025Diamond Contributor
Or
=LOOKUP(2, 1/($A$21:$A$36<=$C48)/($A$21:$A$36>0), $C$21:$C$36)