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. ...
IlirU
Dec 27, 2025Brass Contributor
Or
=XLOOKUP(1, (A21:A48 <= D48) * (B21:B48 >= D48), C21:C48)