The INDIRECT function is "volatile" and probably should be avoided if
possible. Here is a formula that is non-volatile, but it requires you to
place an upper "bound" on the row number where your meeting point can occur
within....

=INDEX(1:1000,B2,A2)

In the above, only values located in cells up to Row 1000 will work. Just
change the 1000 to a row number that will always be larger than the maximum
row a meeting point can take place in.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
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