Thread: Problem - Lookup returning value of last cell in range when no matchoccurs
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Problem - Lookup returning value of last cell in range when nomatch occurs
Hello Ritchie,

Maybe vlookup with the additional (last) parameter 0 (False) will help
you.

Regards,
Bernd
Reply With QuoteReply With Quote