#### ravigupta73

##### New Member

- Joined
- Oct 16, 2006

- Messages
- 1

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