View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Show matching data in several worksheets

Yes, it uses an exact match

"Steve" wrote in message
...
Thank you. I didn't verify all my data, but what I did check seems to be
working.

One more question: It has to be an exact match for the formula to work ,
doesn't it ? Meaning if "Excel" is on one sheet, and "Excel files" is on
another, it won't produce a match, will it ?

Thanks again,

Steve