|
|
Hi
use INDEX. see:
http://www.contextures.com/xlFunctions03.html
--
Regards
Frank Kabel
Frankfurt, Germany
TD wrote:
I have a matrix on sheet 1 with columns and rows. On Sheet 2 I
identify which row I need to use on sheet 1. On Sheet 3 I identify
which column I need to use on sheet 1. How do I combine these two
result to reference a specific cell of the matrix on sheet 1. All I
can get it to show is the name of the cell I want and not the value
in the cell I want.
Thanks
TD
|