+ Reply to Thread
Results 1 to 8 of 8

Turn on VOOKUP with a button

  1. #1
    Registered User
    Join Date
    05-11-2015
    Location
    Bowral, NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    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. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,018

    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))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    05-11-2015
    Location
    Bowral, NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    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?
    Last edited by Mitch199; 05-14-2015 at 02:11 AM. Reason: forgot to add all details!

  4. #4
    Registered User
    Join Date
    02-19-2010
    Location
    Limerick
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Turn on VOOKUP with a button

    try this one

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

  5. #5
    Registered User
    Join Date
    05-11-2015
    Location
    Bowral, NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    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. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,018

    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. #7
    Registered User
    Join Date
    05-11-2015
    Location
    Bowral, NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    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. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,018

    Re: Turn on VOOKUP with a button

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. SUMIF and VOOKUP?
    By shonu1320 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-13-2014, 02:46 PM
  2. invalid reference vookup
    By tjc100 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-28-2014, 09:45 AM
  3. How to turn a cell to a button
    By nenadmail in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2012, 08:08 AM
  4. Multiple Vookup?
    By ChalkerL in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-28-2009, 03:21 AM
  5. Using Vookup to find value or Match?
    By LianCragg in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-26-2007, 11:09 PM

Bookmarks

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