SUM a Vlookup Array Formula
Hi Dave,
Am Fri, 19 Dec 2014 16:52:50 +0000 schrieb Dave011070:
=VLOOKUP($A16&"-"&$B16,DATA,D$5,FALSE).
try:
=SUM(INDEX(Data,,MATCH(A16&"-"&B16,INDEX(Data,1,),0)))
If it does not work please offer your data
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|