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

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?

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

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?

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

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

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

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?
Help Article Resources
Categories
Check out the Formula Handbook template!