Unable to search for a text value with IF
Hi Steve,
Looks pretty complicated from here!
Could the ISERROR function help to replace the error message with a 0?
=IF(ISERROR(whatever),0,whatever)
I only use whatever because I'm uncertain which function you will be
using.
Ken Johnson
|