Maybe I should know this but... I want to reference a cell on sheet 1 from
sheet 2. Then when I sort sheet 1, the reference should follow the value, not
the cell. Basicly, I want to be able to sort and update sheet 1, and not have
to redo any references on sheet 2. Help?
--
GeorgeH

Hi George,

Say you take values on Sheet1 from 1 through 5 in cells A3:A7 (this is your
array)
say in cell A3 on sheet two you take one of the values between 1 through 5
(this is your lookup value)

To see the reference use this function in say cell B3
=ADDRESS(MATCH(A3,Sheet1!A3:A7,0)+2,1,4,1,"Sheet1" )

Try sorting the column on Sheet1, the reference in sheet2 will keep changing
accordingly.

--
Regards,
vijay


"GeorgeH" wrote:

Maybe I should know this but... I want to reference a cell on sheet 1 from
sheet 2. Then when I sort sheet 1, the reference should follow the value, not
the cell. Basicly, I want to be able to sort and update sheet 1, and not have
to redo any references on sheet 2. Help?
--
GeorgeH