Hi,
I have 17 tables of data - each in exactly the same size and format - the y and x axis have values you read down and along to find the correct value at the intersection of s and y axis. Y is 1-90 in increments of 1, x axis is 1-180 in increments of 5.
I have another worksheet in the same workbook with 3 cells (A1, B1, C1) containing data that constantly changes. The value in A1 is always 1-17 and tells me which of the 17 tables I need to go to. The values in B1 (y axis) and C1 (x axis) direct me within the correct table to the value in the cell at the relevant intersection of x and y which is the value I need returned.
So I need a formula that will select the correct table to Index Match Match based on A1, then perform an Index Match Match based on B1 and C1 to return the value I need.
I have tried all sorts of Index Match with indirect and can't get the formula to work. I was wondering if anyone would mind helping? Is this a job for VBA?
Bookmarks