NEED HELP....
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 |
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 |
NEED HELP....
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. |
NEED HELP....
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 |
All times are GMT +1. The time now is 04:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com