3D Lookup - using sumproduct / offset functions?
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.
Reply With Quote
