Too many If's

[stee]

Im trying to add an if formula to excel, i wrote it in word and tried to paste it into excel formula but i get the error formula too long. its about 2/3 a4 page long and looks like this... any suggestions, TIA

IF(B18=E48,A48,0)+IF(B18=E49,A49,0)+IF(B18=E50,A50,0)+IF(B18=E51,A51,0)+IF(B18=E52,A52,0)+IF(B18=E53,A53,0)+IF(B18=E54,A54,0)+IF(B18=E55,A55,0)+IF(B18=E56,A56,0)+IF(B18=E57,A57,0)+IF(B18=E58,A58,0)+IF(B18=E59,A59,0)+IF(B18=E60,A60,0)+IF(B18=E61,A61,0)+IF(B18=E62,A62,0)+IF(B18=E63,A63,0)+IF(B18=E64,A64,0)+

[Carim]

Hi,

With so many If's, you might be better of with one vlookup() function against a reference table ...

[stee]

thanks, ill look thru the help files and see what i come up with

[Carim]

You are welcome ...

Do not hesitate to post back, should you face difficulties ...