Thread: Base the value of one cell on another
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cmartin2459[_2_] cmartin2459[_2_] is offline
external usenet poster
  
Posts: 1
Default Base the value of one cell on another

I have a spread sheet where A5:A237 are dates. Columns B5:D237 are
inputted numbers based on our water usage at 3 different times during
the day.

Cell C2 is =MAX(B5:D231)

I need cell C3 to look at the value in cell C2, search for this value
in cells B5:D237, find the corresponding date in cells A5:A237 and put
that date into C3.

I can't find a function to do this, anyone have any ideas?


--
cmartin2459
------------------------------------------------------------------------
cmartin2459's Profile: http://www.excelforum.com/member.php...o&userid=36530
View this thread: http://www.excelforum.com/showthread...hreadid=562939

Reply With QuoteReply With Quote