PDA

View Full Version : 3D Lookup - using sumproduct / offset functions?



thomas_nz
02-08-2012, 06:44 AM
Hi I am really struggling and would be grateful for some help. I am trying to lookup values from a table and input them into another table. The problem I have is that I cannot use a simple index or vlookup function. I have attached an example of what I am trying to achieve as it is quite difficult to explain in words. I think I need to use a sumproduct / offset formula to input data in row 17,columns b, c and d from the table in rows1:8.

If you could help it would be greatly appreciated.

Bob Phillips
02-08-2012, 08:54 AM
What would you expect to see in B19 and why?