NEED HELP....
I presume you are trying to retrieve the value at that meeting point...
=INDIRECT(CHAR(64+B2)&A2)
--
Rick (MVP - Excel)
"JOSH CONLEY" wrote in message
...
I need a formula to find a cell through locating by row and column, picked
by
a list from two other cells.
CELL A2 HAS A LIST OF DIFFERENT ROWS TO SELECT
CELL B2 HAS A LIST OF DIFFERENT COLUMNS TO SELECT
I WANT CELL E2 TO FIND THE MEETING POINT CELL WHERE ROW AND COLUMN WOULD
MEET THOUGH CELLS A2 AND B2.
--
THANKS,
JOSH
|