Date and time from data table

[Tank1111]

Okay I'm having a mind block on the best way to create a table from user supplied date and time. Once the user updates the date cell and then the time cell it will return only the data specified provided both arguments are true. This data is provided from sheet one where the data is constantly being added to.

Should be simple but today it's not.


Thank you

 

[CSyx]

Tank1111,

Try using Index and Match. Here is a helpful link. VLOOKUP | Excel VLOOKUP | Excel Index & Match Functions