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

[Tapash]

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.....

 

[Mike H]

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

 

[Ag]

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