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)))))))
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)))))))