Thread: MATCH and INDEX combination using multiple criteria?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default MATCH and INDEX combination using multiple criteria?
Hello,

For one special lookup you got the SUMPRODUCT hint already.

If you want it auto-updating for all your combinations have a look at
my UDF Sfreq, please:
http://www.sulprobil.com/html/sfreq.html

Regards,
Bernd
Reply With QuoteReply With Quote