Forum Discussion
IF(OR(ISTEXT
Hi, I’m really struggling with a formula for the following scenario, please can someone help. I have the following ‘Assignment Types’ Short Term Assignment Commuter Arrangement (2015) ...
=IF(ISNUMBER(MATCH(D3,$A$1:$A$2,0)),"Home","Host")
This formula works in my sample file if i understand the question correctly. The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021.
If you have e.g. 10 Assignment Types you can change $A$1:$A$2 to $A$1:$A$10.
=IF(ISNUMBER(MATCH(D3,$A$1:$A$2,0)),"Home","Host")
This formula works in my sample file if i understand the question correctly. The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021.
If you have e.g. 10 Assignment Types you can change $A$1:$A$2 to $A$1:$A$10.
