Forum Discussion
How XLOOKUP arguments apply in this case
I'm not an Excel newbie, but I have never had cause to use XLOOKUP, INDEX, or MATCH before. I'm not understanding how the xlookup arguments would apply in my case or if index/match would be better. ...
This will do it and can handle multiple day returns:
=TOCOL(IF(stitches=MAX(stitches),months&" "&days&", "&year,NA()),2)