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

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

If I understand correctly:

E2: =OFFSET(A1,A2-1,B2-1)

or

E2: =INDEX(A:IV,A2,B2)

Change IV to suit (e.g., for XL07/08, XFD)

In article ,
JOSH CONLEY wrote:

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.

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