Report Value at Row/Col Intersection
Posted by David on May 30, 2001 11:22 AM
Sheet 1 has a table with column headings S1, S2, S3, etc. and row headings labeled W1, W2, W3, etc. (the number to the right of the S or W will not be in any order - i.e. might be S2, S6, S9, etc.). All cells below Sx and to the right of Wx contain different numeric values. On Sheet 2, I'd like to key Sx in one cell, Wx in another cell, then have a third cell return the value in the cell on Sheet 1 where Sx and Wx intersect. Any ideas on a formula for the third cell on Sheet 2 that would accomplish this?