if statement formula

[Ovi]

I have a problem with the following formula:

as it is returning me 0 even when 'Swap Summary'!$C:$C='Credit&Finance'!A30



=IF('Swap Summary'!$B:$B="RBS",IF('Swap Summary'!$C:$C='Credit&Finance'!A30,VLOOKUP('Credit&Finance'!A30,'Swap Summary'!$C:$E,3,FALSE),"0"),"0")

does anyone know why?

 

[Ovi]

brilliant!

that worked!

thanks

 

[Pauljj]

Just for your info, if you want a zero to appear if the conditions are false, you don't need to put quotes around it, numbers don't require it, if you do, you will see the numbers appear as text, ie left alligned