View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jennifer Jennifer is offline
external usenet poster
 
Posts: 385
Default Vertical Lookup Question

Good day, I have a quick question. When using a vertical lookup that looks
at a named table for the returned values, if the item is not present in the
table it returns an N/A. Is there any way to have it return a zero (0) if it
is not present in the table?