Forum Discussion
IF FUNCTION HELP
Hi and Help please! Here's what I'm trying to accomplish but either get a spill error or just a general problem with the formula error. I'm basically asking that from the data in column A2:A1146 if ...
What you've written is a dynamic array formula--If excel is giving you a spill error, your formula wants to return a range and there are values in adjacent cells preventing it from doing so. Clear up some space around the cell your formula is in.
Do you mean that Jackie can be associated with 700047 or 70058, etc?
If so, you want to pop those inside the OR function. Also, remove the range and just leave A2 and drag the formula down column B.
IF(OR($A2=70047, $A2=70058), "Jackie",IF(OR($A2=70053,$A2=70057),"Frezell",IF(... this will solve your issue of the array formula and prevent spill errors. When you drag the formula down column B, A2 will change to A3 in the next row.
