Using VLookup on one table to get a value from another but only looking at certain values?

Hey guys,

Can I have a vlookup formula that looks for a value in another table but only searches for the range of values after a certain date?

Table 1

ID | Date

1 | 04/02/2018
2 | 05/02/2018

Table 2

ID | Quantity | Date
1 | 40 | 02/02/2018
1 | 50 | 05/02/2018
2 | 100 | 06/02/2018


So I would want my Vlookup formula to pick up the 2nd ID = 1 value in table 2 because it is the one after the date in table 1.

Is there any way I can set up a formula to do this?

I did a vba solution where I copied out all the values after a certain date onto a new table and vlookup then copied and pasted the results as values. This worked.

The issue now is that I have to incorporate in the time as well to make sure I am taking the value after the date and time of the date and time in table 1. The vba solution woulnd't work for that because I would have to do to many interval copy and pastes.

Thanks in advance,

D