NEED HELP....

  • Thread starter Thread starter JOSH CONLEY
  • Start date Start date
J

JOSH CONLEY

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.
 
I presume you are trying to retrieve the value at that meeting point...

=INDIRECT(CHAR(64+B2)&A2)
 
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)
 
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 said:
I presume you are trying to retrieve the value at that meeting point...

=INDIRECT(CHAR(64+B2)&A2)
Click to expand...
 
Back
Top