If value is not found show text instead

[avidcat]

With the following formula:

=INDEX(AD38:AD218,MATCH(0,AD38:AD218,0)-1)

If the value is not found I want to display a text "Not Found" instead of #N/A.

Thanks for any help.

Nick

[tigeravatar]

avidcat,

If using Excel 2007 or higher:

Please Login or Register  to view this content.

Excel 2003 and below:

Please Login or Register  to view this content.

[avidcat]

Perfect tiger! Thanks.