Forum Discussion

rach1345's avatar
rach1345
Brass Contributor
Feb 19, 2023
Solved

spill 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...
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Feb 19, 2023

    rach1345 

    Use this instead:

    =IF(ISNUMBER(MATCH(A2,$F$2:$F$17,0)),"GKITTING","N/A")

FikturFox's avatar
FikturFox
Brass Contributor
Feb 19, 2023
Since you have spilled arrays...
You can have a single formula that spills..
ie
=IF(ISNUMBER(MATCH(A2:A588,F2:F17,0)), "GKITTING","NA")

Resources