Travesing to one cell value based on other cell value!!
 

I have 2 work sheets. On worksheet XX1, I have put formula in cell C1 as
MAX(...) where I am getting value of cell C8 of worksheet XX2. Now based on
this C8 of XX2, I want to put C6 of XX2 at C2 of XX1.

I am not getting anything.. I tried to multiplex many formula's but could
not get any.. Is it possible at Excel to do it.....

Travesing to one cell value based on other cell value!!
 

You need to explain the logic of this a bit more thoroughly. Why is that
because C8 is the maximum of a range on XX2 do we make C6(XX2) = C2(XX1)
Mike

"Tapash" wrote:

I have 2 work sheets. On worksheet XX1, I have put formula in cell C1 as
MAX(...) where I am getting value of cell C8 of worksheet XX2. Now based on
this C8 of XX2, I want to put C6 of XX2 at C2 of XX1.

I am not getting anything.. I tried to multiplex many formula's but could
not get any.. Is it possible at Excel to do it.....

Travesing to one cell value based on other cell value!!
 

Assuming MAX function is operating on a single column with fixed
number of rows you can use the following steps

Cell 1 formula =MATCH(MAX(Sheet2!A1:A11),Sheet2!A1:A11)
Cell 2 formula =ADDRESS(B1-2,1,,,"Sheet2")
Cell 3 formula =INDIRECT(B2)

HTH

Regards
Anirudh