View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gigglygover gigglygover is offline
external usenet poster
 
Posts: 6
Default Vlookup with an exact match

Need to use Vlookup to bring data forward, but if there is no exact match
bring back nothing, not one that is the closest value.

my formula so far is =vlookup(a1,NamedRange,2)
looking up a1 from my named range and brining back value from colum 2 in the
named range.
But if A1 does not match anything in the named range then it should either
be blank or put a message perhaps No Match founc
did post this yesterday, but I cannot view the response.