Forum Discussion
If function for a criteria along multiple cells
Hello, please see https://1drv.ms/x/s!AsAcHcm1UiD3ffqpnYLks_cd0yg?e=iLmodB As described in the sheet, in cell E1 I am looking for a formula that will populate with a given word if cell A1 contain...
In E1:
=IF(AND(ISNUMBER(SEARCH("Jess",A1)),ISERROR(MATCH("Jess",B1:D1,0))),"Jess","")
In E7, depending on what you want, either:
=IF(ISNUMBER(MATCH(A7,B1:D1,0)),F1,"")
or
=SUM(IF((B1:B1000=A7)+(C1:C1000=A7)+(D1:D100=A7),F1:F1000))
(If you do not have Microsoft 365 or Office 2021, confirm the latter formula by pressing Ctrl+Shift+Enter)