Thread: NEED HELP....
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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