Too Many Variables When Entering Formula

[jlo33]

When I try to enter a formula, I am told that there are too many variables.

What I currently have is this (give or take a few minor changes)

=IF(COUNTIF('INFO’!A2:A14,’ABSENCE MEMO’!B7),'INFO'!A42,IF('INFO'!A15=’ABSENCE MEMO’!B7,'INFO'!A48),IF('INFO'!A16=’ABSENCE MEMO’!B7,'INFO'!A45),IF('INFO'!A17=’ABSENCE MEMO’!B7,'INFO'!A51,””))

What I am needing is if 10 different options show up in 1 cell, to copy information from another cell. There are another 3 options as well, however, if it is any of those additional 3 - a different cell needs to be copied for each one. For example, I have a total of 13 options - but only 4 different things that would need to be copied over.

I used the same basics for the formula when there was only 2 different things that needed to get copied. I am unsure how to make it work when I have 4 different options now.

Have I confused you yet? LOL.

Thanks for your help!

[martindwilson]

try constructing your if's like this
=IF(COUNTIF('INFO'!A2:A14,'ABSENCE MEMO'!B7),'INFO'!A42, first if
IF('INFO'!A15='ABSENCE MEMO'!B7,'INFO'!A48, second if
IF('INFO'!A16='ABSENCE MEMO'!B7,'INFO'!A45, third if
IF('INFO'!A17='ABSENCE MEMO'!B7,'INFO'!A51, fourth if
"" what to put if none true
)))) number of closing ) = number of ifs ie 4
that becomes when all stringed together

Please Login or Register  to view this content.

[jlo33]

error.docx


Didn't work. I still keep getting this pop up box after

[martindwilson]

here is the formula inserted

[jlo33]

Awesome.

Thanks!