Too Many Variables When Entering Formula

**jlo33** · 11-28-2013, 04:36 PM

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** · 11-28-2013, 04:52 PM

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

Formula:

=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,""))))