Oct 10 2023 11:36 AM
Instead of an image, you would be helping us help you if you posted a copy of the actual spreadsheet. Put it on OneDrive or GoogleDrive with a link here that grants access to it.
Oct 10 2023 12:09 PM
I guess you mean
=MAX( INDEX(B3:I3, MATCH(A3, $B$2:$I$2, 0) ):I3 )
ADDRESS(...):I3 doesn't work. ADDRESS returns cell address as the text, not reference on that cell.