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
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
Last edited by avidcat; 06-21-2013 at 01:02 PM.
avidcat,
If using Excel 2007 or higher:
Excel 2003 and below:Please Login or Register to view this content.
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Perfect tiger! Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks