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")

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Feb 19, 2023

rach1345 

Use this instead:

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

  • rach1345's avatar
    rach1345
    Brass Contributor
    Feb 25, 2023
    thank you this worked 🙂

Resources