Thread: Find exact value using LOOKUP
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ward376 ward376 is offline
external usenet poster
  
Posts: 360
Default Find exact value using LOOKUP
Populate the fourth argument of vlookup with false. If the exact value
isn't found, you'll get an #N/A.

Cliff Edwards

Reply With QuoteReply With Quote