Error in if condition

[Christopher Naveen]

Hi,

I am not getting the result for the below mentioned formula. I request any
one of you to help me in resolving the error.

Error : "You have entered too many arguments for this function"

Formula : =IF(ISERROR(VLOOKUP(CB2,Master!$G:$H,2,0)),IF(VLOOKUP('Base
Data'!G2,Master!$E:$F,2,0)="AS",VLOOKUP('Base
Data'!I2,Master!$A:$C,3,0),IF(VLOOKUP('Base
Data'!G2,Master!$E:$F,2,0)="CS",VLOOKUP('Base
Data'!I2,Master!$A:$D,4,0)),VLOOKUP(CB2,Master!$G:$H,2,0))

Also pls tell me I have 3 nested if conditions here. So I will have 3 false
values accordingly. 1st false value shud be closed at first or last (at the
end of the formual)

Ex : if(1,X,2,Y,3,Z,3,1) or if(1,X,2,Y,3,Z,1,3)

-Christ

 

[Bernie Deitrick]

Christopher,

This is a valid formula:

=IF(ISERROR(VLOOKUP(CB2,Master!$G:$H,2,0)),IF(VLOOKUP('Base
Data'!G2,Master!$E:$F,2,0)="AS",VLOOKUP('Base Data'!I2,Master!$A:$C,3,0),IF(VLOOKUP('Base
Data'!G2,Master!$E:$F,2,0)="CS",VLOOKUP('Base
Data'!I2,Master!$A:$D,4,0),VLOOKUP(CB2,Master!$G:$H,2,0))))

But only you can tell if the logic is correct....

HTH,
Bernie
MS Excel MVP