Forum Discussion
Solved
Showing a cell value if between a time range
Good day I am looking for help with a formula to show a cell value from a range of times. I have a list of specific times, as per below. I have also added 8 time ranges (3 hours ...
I'd organize the lookup table slightly differently:
You can then use VLOOKUP or XLOOKUP:
The formula in B2 is
=VLOOKUP(A2,$E$2:$F$10,2)
or
=XLOOKUP(A2,$E$2:$E$10,$F$2:$F$10,"",-1)
I'd organize the lookup table slightly differently:
You can then use VLOOKUP or XLOOKUP:
The formula in B2 is
=VLOOKUP(A2,$E$2:$F$10,2)
or
=XLOOKUP(A2,$E$2:$E$10,$F$2:$F$10,"",-1)
