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