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(VLOO KUP('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




On Mar 28, 12:44*pm, Christopher Naveen
wrote:
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(VLOO KUP('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

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))))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Christopher Naveen" wrote:
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(VLOO KUP('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