View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michelle7890 Michelle7890 is offline
external usenet poster
 
Posts: 8
Default VLOOKUP returning #N/A

I am using vlook up in a list of accounts that varies from week to week. How
can I make vlookup return a 0 or blank rather than the pesky N/A when a
prticular account is not on the list for the week? The N/A is messing up my
total lines?