Turn on VOOKUP with a button

Hi again everyone.

I now have a table of data that can display certain entires from a constantly changing and updated main log of gas analysis entries.

It works with =VLOOKUP(DATEVALUE("20/03/2015"),C12:I110,4)

In that instance, it is displaying the Nitrogen level for that particular entry, on the 20th of March 2015.

My goal is to have a text box/button at the top of the sheet, that I can type 20/03/2015 in, and BAM! The sheet will display the data using VLOOKUP for that date with the few details i need (nitrogen is one of them).

Does anyone have an idea on how this can be done?

Thanks for all help!

try this one

=if(M35="","",VLOOKUP(M35,C12:I110,4,FALSE))

Thanks for the help Kayteck, unfortunately that one wasnt the answer...

I think because when I type the date in my "date" cell, it is reading it at midnight for that date. So its finding the nearest date possible going backwards.. I guess I need it to read ANY value on that date, or even any entry that is on the date backwards of 23:59... if you know what i mean. So it would read from 11:59pm on that date and automatically grab the nearest one that was entered at say, lunchtime that day.

Anyone got any clues on how to tackle this one? Thanks so much for everything so far.

Hi guys, thanks for all the help, with your answers I got the issue all worked out. Thanks a bunch!! Such good posters on this forum.