Hi all, i have a question on time format when vlookup.
how can i easier to identify (conditional formatting with color or vlookup to return with my request only?) the table below if i want greater than 18:30(subject to change in A1)
<tbody>
</tbody>ps: using cells format: [$-10409]h:mm
formula i use:
thanks all
how can i easier to identify (conditional formatting with color or vlookup to return with my request only?) the table below if i want greater than 18:30(subject to change in A1)
18:45 |
21:30 |
17:15 |
16:30 |
21:00 |
19:45 |
<tbody>
</tbody>
formula i use:
Code:
=IFERROR((VLOOKUP(A10,Sheet1!$Q:$V,6,FALSE)),"")
thanks all