View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CM CM is offline
external usenet poster
 
Posts: 136
Default using THREED function with VLOOKUP to sum across multiple workshee

I have downloaded this function, but cannot seem to make it work. I need to
sum up 13 sheets using a vlookup reference (cell B13). This is what I used:

=SUM(VLOOKUP(B13,THREED(EUR:VGS!$B$12:$V$120),6,0) )

EUR:VGS are the sheet names. Each sheet in between has a different name. Is
my naming convention not going to work? Right now it only returns the value
from the first sheet (EUR) only.

Thanks
CM