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!
Bookmarks