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)
[TABLE="width: 500"]
<tbody>[TR]
[TD]18:45[/TD]
[/TR]
[TR]
[TD]21:30[/TD]
[/TR]
[TR]
[TD]17:15[/TD]
[/TR]
[TR]
[TD]16:30[/TD]
[/TR]
[TR]
[TD]21:00[/TD]
[/TR]
[TR]
[TD]19:45[/TD]
[/TR]
</tbody>[/TABLE]
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)
[TABLE="width: 500"]
<tbody>[TR]
[TD]18:45[/TD]
[/TR]
[TR]
[TD]21:30[/TD]
[/TR]
[TR]
[TD]17:15[/TD]
[/TR]
[TR]
[TD]16:30[/TD]
[/TR]
[TR]
[TD]21:00[/TD]
[/TR]
[TR]
[TD]19:45[/TD]
[/TR]
</tbody>[/TABLE]
ps: using cells format: [$-10409]h:mm
formula i use:
Code:
=IFERROR((VLOOKUP(A10,Sheet1!$Q:$V,6,FALSE)),"")
thanks all