Solved: How do I get rid of #N/A with a Index Match Formula

[boynejs]

I am getting #N/A with the following equation

=INDEX($C$2:$C$367,MATCH(MAX(G$2:G$367),G$2:G$367,0)

C= List of Days
G = Daily River Stages

I have #N/A for one day on February 29 in the list of days. It works well when you are in a leap year when you have a value.

How do I fix it?

Thanks for the help!

Jeff B

[JohnTopley]

Try

=IFERRORr(INDEX($C$2:$C$367,MATCH(MAX(G$2:G$367),G$2:G$3679,0),"")

[boynejs]

Hi John,

Thanks for the response! I tried your equation and it produces a blank. I would like it to return a date.

Jeff

[AliGW]

What date? e.g.

=IFERROR(INDEX($C$2:$C$367,MATCH(MAX(G$2:G$367),G$2:G$3679,0),DATE(2024,2,29))