help please =)

[vrmomo]

I'm using vlookup to look up a value in sheet1 to instert it into
sheet2

=VLOOKUP(A5,Sheet1!A6:C23,3,FALSE)

When I have a value in sheet2 that doesn't match with sheet1 I get an
"#N/A"

Is there a way to replace the #N/A with "0.00"

thanks

 

[anilsolipuram]

=if(isna(VLOOKUP(A5,Sheet1!A6:C23,3,FALSE)),"0.00",VLOOKUP(A5,Sheet1!A6:C23,3,FALSE)

 

[vrmomo]

=if(isna(VLOOKUP(A5,Sheet1!A6:C23,3,FALSE)),"0.00",VLOOKUP(A5,Sheet1!A6:C23,3,FALSE))

thanks anilsoli

 

[Nick Hodge]

Add an IF and ISERROR statement

=IF(ISERROR(VLOOKUP(A5,Sheet1!A6:C23,3,FALSE)),0,VLOOKUP(A5,Sheet1!A6:C23,3,FALSE))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)