I am trying to display a value in a cell based on anothers criteria (IF). So what I am trying to do is this (see picture as well).
IF the ECT Value is 32 ECT B or 32 ECT C THEN show "SP3-23M-SP3". IF ECT Value is 44 ECT C or 44 ECT B then show "SP4-23M-SP4". IF ECT Value is 51 ECT BC then show "SP3-23M-SP3-23M-SP3"
I've tried to use an array formula as well as an IF statement.
Array forumla: {=INDEX($B$A2:$B$A6,MATCH(TRUE,ISNUMBER(SEARCH($A$Z2:$A$Z6)),0)} IF statement: =IF(OR(ISNUMBER(SEARCH("32 ECT C",AI4)),ISNUMBER(SEARCH("32 ECT B",AI4))),"SP3-23M-SP3","False")
The array I am just getting an error. Not sure why. I pretty much toook that from a response on here. The If or statement is working - but for only the conditions I need to return as the one value. I need to do this for 2 other return values. Is that possible?