View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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