Thread: Vlookup return Zero if not there
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Troy[_2_] Troy[_2_] is offline
external usenet poster
  
Posts: 18
Default Vlookup return Zero if not there
I'm doing a vlookup. If the value I"m looking up is not in the arrary I've
set up I want the formual to return a zero.

Here's the formula: =VLOOKUP(C11,'Payment Matrix'!B128:C134,2,TRUE)
Reply With QuoteReply With Quote