Thread: Function to find only exact matches in spreadsheets?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default Function to find only exact matches in spreadsheets?
VLOOKUP accepts an optional fourth argument. Without it, you get a 'range
lookup.' If you supply FALSE as the fourth argument, vlookup looks for an
exact match: =vlookup(value, table, column#, FALSE).

"Pam1288" wrote:

Is there a function similar to VLOOKUP, that will only find exact matches
between spreadsheets?
Reply With QuoteReply With Quote