Is there a way to find the address of a cell with a certain value?
 

I have a grid in an spreadsheet that is 8X8 there are 20 different values in
the grid. What I want is to have a function that will search for the cell
address of a given value. THEN, once I find that Address is there a way to
find out what the value is in the cell above,left,right, and below a given
number of cells????

Is there a way to find the address of a cell with a certain value?
 

Try something like this:

For an 8x8 table of values in A1:H8

J1: FindVal
K1: 37

J2: RowOffset
K2: -1

J3: ColOffset
K3: 3

J4: NewValue
K4:
=INDEX(A1:H8,SUMPRODUCT((A1:H8=K1)*ROW(A1:H8))+K2, SUMPRODUCT((A1:H8=37)*COLUMN(A1:H8))+K3)

The formula in K4 locates the K1 value in the table and returns the
contents of the cell that is offset from that value by the number of rows and
columns referenced in K2 and K3, respectively.

In the above example, the formula finds the number 37 in the table and
returns the value that is 1 row UP and 3 cells the the RIGHT of that cell.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Oshtruck user" wrote:

I have a grid in an spreadsheet that is 8X8 there are 20 different values in
the grid. What I want is to have a function that will search for the cell
address of a given value. THEN, once I find that Address is there a way to
find out what the value is in the cell above,left,right, and below a given
number of cells????