help please =)

  • Thread starter Thread starter vrmomo
  • Start date Start date
V

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" :confused:

thanks
 
=if(isna(VLOOKUP(A5,Sheet1!A6:C23,3,FALSE)),"0.00",VLOOKUP(A5,Sheet1!A6:C23,3,FALSE)
 
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)
 
Back
Top