jordiejones
New Member
- Joined
- May 5, 2010
- Messages
- 31
This is the original formula that searches one cell for the value and it works:
Here's what I've tried with no avail:
&
any help would be greatly appreciated
*can't use IFS
Excel Formula:
=IFERROR(IF(SEARCH("*MEDI-CAL*",'Phone Referral'!A6,1),"X1",””),"F")
Excel Formula:
=IFERROR(IF(SEARCH("*MEDI-CAL*",'Phone Referral'!A6,1),"X",IF(SEARCH("*MEDI-CAL*",'Phone Referral'!D10,1),"X","")),"F")
Excel Formula:
=IFERROR(IF(OR(SEARCH("*MEDI-CAL*",'Phone Referral'!A6,1),SEARCH("*MEDI-CAL*",'Phone Referral'!D10,1)),"X1",””),"F")
*can't use IFS