I have a INDEX MATCH formula which uses TIMEVALUE to look up a time range.
=MIN(IF($C$2:$C$50=A2,IF($B$2:$B$50>=TIMEVALUE("10:00"),IF($B$2:$B$50<=TIMEVALUE("11:00"),$A$2:$A$50))))
Instead of TIMEVALUE("10:00") in the formula If I had a cell with a time in it, could I reference that cell instead of the "10:00"
example TIMEVALUE("G2") if G2 had the time 12:00pm in it ?? (I tried this but doesn't work?)
Bookmarks