#N/A Error of to many arguments

[Jbooze]

The following formula works well as long as the vlookup finds data. I need to work an IFNA into this formula, but since I have an "IF" condition before the vlookup, I can't add ifna in front of the vlookup or I will get an error of to many arguments. Am I missing a simple work-around on this?

=IF(B3="","",IF(C3="","Enter Name",IF('PFP Goals'!$C$39=1,(VLOOKUP($C3,'Jan-Pay Paste'!$C$4:$Z$498,3,FALSE)),IF('PFP Goals'!$C$39=2,(VLOOKUP($C3,'Feb-Pay Paste'!$C$4:$Z$498,3,FALSE)),IF('PFP Goals'!$C$39=3,(VLOOKUP($C3,'Mar-Pay Paste'!$C$4:$Z$498,3,FALSE)),IF('PFP Goals'!$C$39=4,(VLOOKUP($C3,'Apr-Pay Paste'!$C$4:$Z$498,3,FALSE)),IF('PFP Goals'!$C$39=5,(VLOOKUP($C3,'May-Pay Paste'!$C$4:$Z$498,3,FALSE)),IF('PFP Goals'!$C$39=6,(VLOOKUP($C3,'Jun-Pay Paste'!$C$4:$Z$498,3,FALSE)),IF('PFP Goals'!$C$39=7,(VLOOKUP($C3,'Jul-Pay Paste'!$C$4:$Z$498,3,FALSE)),IF('PFP Goals'!$C$39=8,(VLOOKUP($C3,'Aug-Pay Paste'!$C$4:$Z$498,3,FALSE)),IF('PFP Goals'!$C$39=9,(VLOOKUP($C3,'Sep-Pay Paste'!$C$4:$Z$498,3,FALSE)),IF('PFP Goals'!$C$39=10,(VLOOKUP($C3,'Oct-Pay Paste'!$C$4:$Z$498,3,FALSE)),IF('PFP Goals'!$C$39=11,(VLOOKUP($C3,'Nov-Pay Paste'!$C$4:$Z$498,3,FALSE)),IF('PFP Goals'!$C$39=12,(VLOOKUP($C3,'Dec-Pay Paste'!$C$4:$Z$498,3,FALSE)),0))))))))))))))

Thanks,

Jeff

 

[jtakw]

You're welcome Robby19, 64 levels of IFs, omg, that would be a nightmare! As you said, before I get Anywhere near that, I would definitely try to find another way...