Excel Iferror function help

[nelsonjos]

Hello,

I am trying to add an iferror to my index function to give me an error message.

I have 4 columns A) Years, B) Interceptions, C) Yards, D) Wins. There are a list of years from 1991 to 2010 in column A. I have two input cells one for years and desired stats. The output cell gives me the required stat with the formula =INDEX($B$6:$D$25,MATCH(G6,A6:A25,0),MATCH(G7,$B$5:$D$5,0))

I want to be able to give an error message when there is a year that is outside of my 1991-2010 range.

I have been trying to add an iferror function but every time I do it gives me an error message.

Thanks so much.

 

[Andrew Poulsom]

Try:

=IFERROR(INDEX($B$6:$D$25,MATCH(G6,A6:A25,0),MATCH(G7,$B$5:$D$5,0)),"Error Message")

 

[nelsonjos]

Yeah that works but is there a way that I can limit it to the year. When I enter an invalid name in my other input cell it still gives me the same error message.

 

[Andrew Poulsom]

Not with IFERROR, but try:

=IF(MEDIAN(G6,A6:A25)=G6,INDEX($B$6:$D$25,MATCH(G6,A6:A25,0),MATCH(G7,$B$5:$D$5,0)),"Wrong Year")

 

[nelsonjos]

That's it thank you so much for your help!