Hi,
Please see the attached file.
I am trying to populate cells "Calc!D4:F4" with text data entered randomly in cell D4 in the subsequent worksheets. My "if" formula for cell "Calc!D4" is pretty long currently (using indirect- index- Match function) for looking at each cell inthe subsequent sheets sequentially. The formula gets longer for the subsequent two cells. (E4 and F4). I am looking for a simpler solution, as I am pretty sure there would be one! I can't use VBA since the end users will be accessing this file via excel on line.
Thanks in advance,
Bharath Srivatsa
Bookmarks