View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
57Caddy 57Caddy is offline
external usenet poster
 
Posts: 18
Default Vlookup to Equal Zero?

Hello,

I am doing several lookups to several sheets and have attached an example
below. How can I get it to display as zero as opposed to N/A if it can't find
the item looked up?

=VLOOKUP(A2, '9-7Turnover'!$A$1:$F$32, 6, FALSE)

Thank you