Hi, Andy, thanks for your response. I just looked out your website and it looks like there is a lot of good information there. I think it will be helpful.



On Saturday, July 13, 2013 7:14:30 AM UTC-4, wrote:
This is one of the areas where Lotus 123 still scores over Excel. Lotus had a function called XINDEX that did what you want. You can use INDEX and MATCH to achieve what you want; you can also use SUMPRODUCT. Here is a link to a demo on my website:



http://www.bygsoftware.com/Excel/fun...sumproduct.htm



HTH

Andy