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
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