I am trying to max value a range, based on criteria for the range row, and everything I tried so far doesn't work, so your help will be greatly appreciated.

Ex:

Sheet1

A1:A200 = 02:00:00 AM, 03:00:00 AM, 04:00:00 AM, 05:00:00 AM...etc

B1:B200 = values

Sheet2

A1= 04:00:00 AM

B1=Sheet name (Sheet1)

C1= Max formula (=MAX(INDIRECT("'"&B1&"'!"&"B3:B200"))

I need the formula to max value to corespondent range.

If A1=02:00:00 AM, then the range for max values to be B1:B200

If A1=04:00:00 AM, then the range for max values to be B3:B200

....etc

It would really help to change only the value in A1 and the formula to work with the new range, according to the A1 criteria.

I only need to change the starting row of the range( B1, B2,...etc.

Can this be done in just one formula? I am trying to avoid using too many formulas to retrieve cell and column numbers.

Thank you in advance,

Stef.