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.