ISERROR Help

[matthewlouis]

I am trying to keep cells from having an error using iserror function . . . but I can't seem to get my arguments correct on the following:

=IF(AQ3<>0,INDEX(AL$3:AL$62,MATCH(AQ3,AM$3:AM$62,0)),"")

How would I write this using the ISERROR function to keep error out of cells?

Thanks in advance!!!

 

[KevCarter]

Here is what I try to do:

[COLOR=#000000][FONT=&quot]=IF([COLOR=#0057d6]AQ3[/COLOR]<>0,IFERROR[COLOR=#006107]([/COLOR]INDEX[COLOR=#ab30d6]([/COLOR][COLOR=#006107]AL$3:AL$62[/COLOR],MATCH[COLOR=#a54a29]([/COLOR][COLOR=#0057d6]AQ3[/COLOR],[COLOR=#ab30d6]AM$3:AM$62[/COLOR],0[COLOR=#a54a29])[/COLOR][COLOR=#ab30d6])[/COLOR],""[COLOR=#006107])[/COLOR],"")[/FONT][/COLOR]

I hope I have it right and it helps!

Kevin

 

[matthewlouis]

Thanks, Kevin, works great, appreciate it!!

 

[KevCarter]

Thrilled to help, you made my day letting me know it worked!!!

Cheers Matthew