The formula is missing an opening or closing parenthesis.
=IF(ISBLANK($C$2), 0, SEARCH($C$2,$I4&$J4)
what's wrong with this formula?
The formula is missing an opening or closing parenthesis.
=IF(ISBLANK($C$2), 0, SEARCH($C$2,$I4&$J4)
what's wrong with this formula?
You can't use search like that.
Try this
=IF(ISBLANK($C$2),0,IF(COUNTIF(I4:J4,C2),"found","not found"))
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks