IF Formula

[Angus95]

Hi,

Is there a better way to achieve this formula?


=IF(H8=Budget!$L$5,I8*Budget!$M$5,IF(H8=Budget!$L$6,I8*Budget!$M$6,IF(H8=Budget!$L$7,I8*Budget!$M$7,IF(H8=Budget!$L$8,I8*Budget!$M$8,IF(H8=Budget!$M$9,I8*Budget!$M$9,IF(H8=Budget!$L$10,I8*Budget!$M$10,IF(H8=Budget!$L$11,I8*Budget!$M$11,””))))))))&IF(H8=Budget!$L$12,I8*Budget!$M$12,IF(H8=Budget!$L$13,I8*Budget!$M$13,IF(H8=Budget!$L$14,I8*Budget!$M$14,IF(H8=Budget!$L$15,I8*Budget!$M$15,IF(H8=Budget!$L$16,I8*Budget!$M$16,IF(H8=Budget!$L$17,I8*Budget!$M$17,IF(H8=Budget!$L$18,I8*Budget!$M$18,””)))))))&IF(H8=Budget!$L$19,I8*Budget!$M$19,IF(H8=Budget!$L$20,I8*Budget!$M$20,IF(H8=Budget!$L$21,I8*Budget!$M$21,IF(H8=Budget!$L$22,I8*Budget!$M$22,IF(H8=Budget!$L$23,I8*Budget!$M$23,IF(H8=Budget!$L$24,I8*Budget!$M$24,IF(H8=Budget!$L$25,I8*Budget!$M$25,)))))))


Thanks in advance.

Angus

 

[Yongle]

How about (untested) ....

=I8*INDEX(Budget!M5:M25,MATCH(H8,Budget!L5:L25,0))

 

[Michael M]

How about...

=VLOOKUP(H8,Budget!L5:M25,2,0)*I8

 

[Angus95]

Yeah the second I posted i remeberd Vlookup, thanks for that!

 

[Michael M]

Glad we could help...thx for the feedback..