If condition error

  • Thread starter Thread starter Christopher Naveen
  • Start date Start date
C

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
 
5 row formula which has Data'!I2,Master!$A:$D,4,0)) remove one
bracket...and add two more bracket (closing bracket) at the end.

I think u will be able to get the result
 
Try pasting this revision into your formula bar:
=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))))
 
Back
Top