ISNA VLOOKUP formula error

[towners]

Hi,

I'm attempting to create a formula that sets to zero any cell that is blank on my VLOOKUP. The VLOOKUP works fine however when I use this code I get "formula contains an error" and the "0" is highlighted.

=IF(ISNA(VLOOKUP($B$1&"Line "&$A$5&$B5,'Daily Data'!$A:$AA,19,FALSE),0,VLOOKUP($B$1&"Line "&$A$5&$B5,'Daily Data'!$A:$AA,19,FALSE))

Can anyone help? btw it's excel 2002

Many thanks

Paul

 

[VoG]

Try

=IF(ISNA(VLOOKUP($B$1&"Line "&$A$5&$B5,'Daily Data'!$A:$AA,19,FALSE)),0,VLOOKUP($B$1&"Line "&$A$5&$B5,'Daily Data'!$A:$AA,19,FALSE))

 

[towners]

You're a very, very, very nice man. Thank you for swift and effective response - have a great day!