rach1345Brass ContributorFeb 19, 2023Solvedspill error I have set up a table in cell f1 – f18. Cell f1 has the column header in and the other 17 lines have material names in. I have inserted the following formula =IF(A2=$F$2:$F$17,"GKITTING","N/A") so i...Show Morespillformula 19022022.xlsx41 KBRiny_van_EekelenFeb 19, 2023rach1345 Use this instead:=IF(ISNUMBER(MATCH(A2,$F$2:$F$17,0)),"GKITTING","N/A")
Riny_van_EekelenFeb 19, 2023rach1345 Use this instead:=IF(ISNUMBER(MATCH(A2,$F$2:$F$17,0)),"GKITTING","N/A")
Riny_van_EekelenFeb 19, 2023rach1345 Use this instead:=IF(ISNUMBER(MATCH(A2,$F$2:$F$17,0)),"GKITTING","N/A")
SergeiBaklanDiamond ContributorFeb 20, 2023rach1345 Variation could be =IF( ISNA( XMATCH(A2:A588,F2:F17) ), "no such", "GKITTING" )
