thank you so much for the reply Claus, really appreciated.
unfortunately it doesn't work for me but I am hoping if you have a few minutes you may see what I am trying to do in the attached spreadsheet.
I have had to cut it right down to an example of the problem as it is a 5MB file otherwise, but I hope it gives you an idea of what I am trying to achieve
thank you again, really appreciate your help
Dave
Quote:
Originally Posted by Claus Busch
Hi Dave,
Am Fri, 19 Dec 2014 19:07:12 +0100 schrieb Claus Busch:
=SUM(INDEX(Data,,MATCH(A16&"-"&B16,INDEX(Data,1,),0)))
if you want sum the same column you detected with VLOOKUP then try:
=SUM(INDEX(Data,,MATCH(A16&"-"&B16,INDEX(Data,1,),0)+$D$5-1))
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|