Hi All
I need to return to my current worksheet, Say 'Sheet1' , the value in a matrix on a different worksheet, Say 'Sheet 10' by using, I assume, Index, Match,Match lookup formula.
This is complicated by the fact that the values to use for reference for the Index are on 'Sheet1' - Column= 'G'...