Need help with Excel formula VLOOKUP

[EddScott]

I understand that in Excel you can only have 7 IF functions in a formula?

What happens if I have need more than 7 IFs ? Can I use VLOOKUP ?

Cell A1 could have up to 50 different codes (IR1, IR2 etc) and depending on which code is in the cell would determine in what manner a figure is split up.

So if A1 has the code, B1 has the start value and C1,C2,C3 all have different finishing values depending on the calculation determined by what code is in A1.

So If A1 say code "IR1" and B1 has £100 - IR1 requires the £100 to be split 20%, 10%, 70% and the percentages would appear in C1, C2, C3.

Can I use VLOOKUP for this? If the first column in the VLOOKUP table is the code and the 2nd column in VLOOKUP is the required calculation.

Any help really appreciated!

 

[EddScott]

Wow, that is spot on!!

Many thanks mate

 

[EddScott]

Linkex - can I call on your knowledge one more time?

Is it possible to add 3 more columns next to the figures which provide the % in the form of 10%, 20%, 30%?

So in the top table, where it has £10 £10 £70 can I include £10 10% £10 10% £70 70% as 3 extra columns - all changing in relation to the IR code same as the figures.

I've been fiddling with it and can't make it work.

Again, all help much appreciated!


EDIT - Aha, got it. Thanks again anyway