Forum Discussion
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 want it to return “Gkitting” if any of these cells contain that material number (16 material numbers) altogether. The formula is looking for that material name in 16 columns just for a2. How do i resolve this issue?
4 Replies
- Since you have spilled arrays...
You can have a single formula that spills..
ie
=IF(ISNUMBER(MATCH(A2:A588,F2:F17,0)), "GKITTING","NA") - thank you this worked 🙂
