Hello,
I've been looking around and I'm not sure if it's possible, but I would like to know if there's an equivalent to Java's break(); function in basic excel formulas. For those who don't know Java, the break() essentially, I'm looking for a way to exit a formula early under certain conditions, so that the cell's value would evaluate to be blank.
This is the formula I'm currently using:
=IF(ISNA((INDEX('Master New Hire List.xlsx]Sheet2'!$L:$L,MATCH(IF(("*"&K7&"*")="**",NA(),"*"&K7&"*"),'Master New Hire List.xlsx]Sheet2'!$AQ:$AQ,0)))), NA(),"✓")
K7 is a column which contains potential new email addresses. Right now, by design it is throwing a N/A if K7 is a blank cell. 'Master New Hire List.xlsx]Sheet2'!$L:$L returns a name, and 'Master New Hire List.xlsx]Sheet2'!$AQ:$AQ is searching through another database of known email addresses.
The reason I am looking for this functionality at all is that I need some way to differentiate between errors due to a nonmatch, and errors due to there being no data in K7. If there is no break(); function in basic excel formulas, I would also appreciate any advice on another way I could go about doing this.
Thanks so much!
BTW: sorry if this would better fit in Formula's and Functions--I wasn't sure.
Bookmarks