Query related to Nested IF Formula in MS Excel 2002

ravigupta73

New Member
Joined
Oct 16, 2006
Messages
1
I have an excel sheet where I am getting summery of information by selecting the product in a dropdown menu.

I have used nested IF formula to achieve this.

This formula is working fine but taking only 7 arguements.

I want to add more arguements. The formula is given below: Please help!

=IF($B$2="Sub Base",VLOOKUP(A4,$IG$94:$IS$120,2,0),IF($B$2="Revenue",VLOOKUP(A4,$IG$3:$IS$29,2,0),IF($B$2="Gross Adds",VLOOKUP(A4,$IG$34:$IS$60,2,0),IF($B$2="Churn",VLOOKUP(A4,$IG$64:$IS$90,2,0),IF($B$2="Net Adds",VLOOKUP(A4,$IG$124:$IS$150,2,0),IF($B$2="ARPU",VLOOKUP(A4,$IG$154:$IS$180,2,0)))))))
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

shajueasow

Well-known Member
Joined
Oct 7, 2004
Messages
1,926
The nesitng level limit IS upto seven levels. Otherwise you will have to use excel 2007.
 

sailepaty

Active Member
Joined
Nov 1, 2005
Messages
279
This could be a solution:

=VLOOKUP(A4,CHOOSE(MATCH($B$2,{"Sub Base";"Revenue";"Gross Adds";"Chum";"Net Adds";"ARPU";"NEW OPTION"},0),$IG$94:$IS$120,$IG$3:$IS$29,$IG$34:$IS$60,$IG$64:$IS$90,$IG$124:$IS$150,$IG$154:$IS$180,NEW RANGE),2,0)

Change the NEW OPTION and NEW RANGE for your real Text and Range.

Regards
 

Watch MrExcel Video

Forum statistics

Threads
1,114,040
Messages
5,545,676
Members
410,697
Latest member
srishtijain0708
Top