Error Message HELP

Shannon Lacerda

What am I doing wrong, my formula was working then I tried to add the (@cell) function and now I get the error message

Paul Newcome

There is no IFS function. Your formula should not have been working even before adding the @cell references.

What error message are you getting exactly?

Shannon Lacerda

I removed the "S" from the IFS and I get the #INCORRECT ARGUMENT SET message

Paul Newcome

My apologies. I didn't mean that was the only issue with the formula. I was just confused as to how you had it working before the @cell references were added since it should not have been.

What exactly are you wanting to accomplish with your formula?

Shannon Lacerda

Sorry I added the "S" when I tried adding the (@cell)s

Paul Newcome

Ah. Ok. What exactly are you wanting to accomplish with your formula?

Shannon Lacerda

I need to define a specific job number to the formula from the 2 sheets referenced later in the formula

Paul Newcome

Can you provide more detail and screenshots of what you are working with as well as some manually entered data to show your end goal?