Thread: VLOOKUP - 0 instead of # N/A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jaleel Jaleel is offline
external usenet poster
  
Posts: 187
Default VLOOKUP - 0 instead of # N/A
Hi,

=VLOOKUP(G3,A:D,4,FALSE)

When I put the above formula, if the lookup_value is not available in the
table_array #N/A appears in the result. How can I modify the formula to get
the result as 0 instead of #N/A?

Can anybody help?

Jaleel
Reply With QuoteReply With Quote