Stumped on IF and VLOOKUP

[Adnil]

Hi All

I am having one of those days... This formula worked yesterday... today it doesnt and I cant see what I have done.

=IF(C32,(VLOOKUP(E6,'Annuity Tables'!$A:$F,2,0)),(0))=IF(E32,(VLOOKUP(E6,'Annuity Tables'!$A:$F,3,0)),(0))=IF('Data Sheet'!G32,(VLOOKUP(E6,'Annuity Tables'!$A:$F,4,0)),(0))=IF('Data Sheet'!I32,(VLOOKUP(E6,'Annuity Tables'!$A:$F,5,0)),(0))

It jsut wont work! the cells C32, E32, G32 and I32 all have either True or false in them (from check boxes)

I tried this section of the formula and it works perfectly.
=IF(E32,(VLOOKUP(E6,'Annuity Tables'!$A:$F,2)))

But as soon as I put the others in it displays "False"

I just cant see the problem anymore. Any help is greatly appreciated.

Thanks

<TABLE style="WIDTH: 77pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=102 border=0 x:str><COLGROUP><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" width=102><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl25 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 77pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=middle width=102 height=17 x:bool="FALSE">

​

</TD></TR></TBODY></TABLE>

 

[Andrew Poulsom]

Maybe:

=IF(C32,VLOOKUP(E6,'Annuity Tables'!$A:$F,2,0),IF(E32,VLOOKUP(E6,'Annuity Tables'!$A:$F,3,0),IF(G32,VLOOKUP(E6,'Annuity Tables'!$A:$F,4,0),IF(I32,VLOOKUP(E6,'Annuity Tables'!$A:$F,5,0),0))))

 

[Adnil]

Brilliant, brilliant.

Thank you Andrew you are a superstar... all fixed now.