I am currently using Excel 2007 but much of our company runs on Excel 2003. When I tried to save my excel spreadsheet down I ran into some problems with the formulas. I need to find a way to narrow down this formula so it will work in Excel 2003. Any help would be great!

=IF(B21="Urethane",LOOKUP($C$12,Reference!$A$3:$A$21,Reference!$I$3:$I$21),IF(B21="Splatter",LOOKUP($C$12,Reference!$A$3:$A$21,Reference!$J$3:$J$21),IF(B21="Rhino",LOOKUP($C$12,Reference!$A$3:$A$21,Reference!$K$3:$K$21),IF(B21="Surlyn",LOOKUP($C$12,Reference!$A$3:$A$21,Reference!$L$3:$L$21),IF(B21="Surlyn FDA",LOOKUP($C$12,Reference!$A$3:$A$21,Reference!$M$3:$M$21),IF(B21="Sheet Urethane",LOOKUP($C$12,Reference!$A$3:$A$21,Reference!$N$3:$N$21),IF(B21="Teflon",LOOKUP($C$12,Reference!$A$3:$A$21,Reference!$O$3:$O$21),IF(B21="No-Mar Teflon",LOOKUP($C$12,Reference!$A$3:$A$21,Reference!$P$3:$P$21),IF(B21="Green Brush",LOOKUP($C$12,Reference!$A$3:$A$21,Reference!$Q$3:$Q$21),IF(B21="Black Brush",LOOKUP($C$12,Reference!$A$3:$A$21,Reference!$R$3:$R$21),IF(B21="Electro-Polish",LOOKUP($C$12,Reference!$A$3:$A$21,Reference!$S$3:$S$21),IF(B21="Epoxy Paint",LOOKUP($C$12,Reference!$A$3:$A$21,Reference!$T$3:$T$21),IF(B21="Rubber",LOOKUP($C$12,Reference!$A$3:$A$21,Reference!$U$3:$U$21),IF(B21="UHMW",LOOKUP($C$12,Reference!$A$3:$A$21,Reference!$V$3:$V$21),IF(B21="Red Urethane",LOOKUP($C$12,Reference!$A$3:$A$21,Reference!$W$3:$W$21),0)))))))))))))))


Yes I know its ugly!

Thanks in advance, oh and new to the forum!