View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tapash Tapash is offline
external usenet poster
 
Posts: 1
Default 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.....