# Turn on VOOKUP with a button

1. ## 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!

2. ## Re: Turn on VOOKUP with a button

You dont need a text box or button, just enter the date into a cell - say A1 - and reference that in your formula...

=if(a1="","",VLOOKUP(a1,C12:I110,4))

3. ## Re: Turn on VOOKUP with a button

Ok thanks for the fast response.

You guys are awesome.

So if I wanted the date entry cell to be, for example, M35.

The formula would be: =if(M35="","",VLOOKUP(M35,C12:I110,4))

This is awesome, except it is actually giving me the previous entry nitrogen level, for example, if i type in 20/03/2015 i get the level from the 18/03/2015

Any ideas on how to get the formula to show the correct nitrogen value, which is a row below?

4. ## Re: Turn on VOOKUP with a button

try this one

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

5. ## Re: Turn on VOOKUP with a button

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.

6. ## Re: Turn on VOOKUP with a button

Apologies, I left off the last argument...
=if(M35="","",VLOOKUP(M35,\$C\$12:\$I\$110,4,0))

However, this will find the very 1st instance of that date. It will not take any times into consideration.

If you need it to consider more than 1 "match", I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

7. ## Re: Turn on VOOKUP with a button

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.

8. ## Re: Turn on VOOKUP with a button

Happy we got you where you wanted to be, and thanks for the feedback

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1