=IFERROR(IFERROR(VLOOKUP('SSI Data Dump'!I2,Assumptions!$B$2:$D$39,3,false),IF(I2="EPR",VLOOKUP('SSI Data Dump'!C3,EPARS!$AI:$AL,4,false)),IF(A2="PHYS","Molly Rodenbeck",IF(L2="Yes","Sarena Pitts","Molly Rodenbeck"),"Molly Rodenbeck")
What's wrong with this formula?
try this
=IFERROR(isERROR(VLOOKUP('SSI Data Dump'!I2,Assumptions!$B$2:$D$39,3,false)),
IF(I2="EPR",VLOOKUP('SSI Data Dump'!C3,EPARS!$AI:$AL,4,false),IF(A2="PHYS","Molly Rodenbeck", IF(L2="Yes","Sarena Pitts","Molly Rodenbeck"),"Molly Rodenbeck")
This part...
IF(I2="EPR",VLOOKUP('SSI Data Dump'!C3,EPARS!$AI:$AL,4,false) )
does not have a 3rd argument...
IF(I2="EPR", VLOOKUP('SSI Data Dump'!C3,EPARS!$AI:$AL,4,false),???? )
The last 2 formulas seem to be just haning out there...
IF(A2="PHYS", "Molly Rodenbeck", IF(L2="Yes", "Sarena Pitts","Molly Rodenbeck"),"Molly Rodenbeck")
My personnel preference is to nest IFERROR's inside the formula string....
=IFERROR(formula,IFERROR(formula,IFERROR(formula)))
What exactly are you trying to do here anyway?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks