+ Reply to Thread
Results 1 to 3 of 3

Vlookup will not reference a validation/drop down box

  1. #1
    Dave
    Guest

    Vlookup will not reference a validation/drop down box

    Is there a way to use a drop down box as the criteria in vlookup. We have a
    list of months and the corresponding days in the month. When someone selects
    the month from a drop down list, the appropriate number of days should be
    returned from the vlookup. The lookup is returning the wrong number of days
    for the selected month.

    Example

    Drop down validation uses the months in column M. The drop down is in cell
    D1.

    Vlookup in F1 - VLOOKUP(D1,M8:N19,2)

    Col M Col N Rows 8-19
    October 21
    November 22
    December 23
    January 21
    February 20
    March 23
    April 21
    May 22
    June 22
    July 21
    August 23
    September 22

    As is, the vlookup returns 20 for July. Is there a way to fix the error.

    Thanks

  2. #2
    Biff
    Guest

    Re: Vlookup will not reference a validation/drop down box

    Hi!

    >VLOOKUP(D1,M8:N19,2)


    Try changing the formula to:

    =VLOOKUP(D1,M8:N19,2,0)

    See if that helps.

    Biff

    "Dave" <[email protected]> wrote in message
    news:[email protected]...
    > Is there a way to use a drop down box as the criteria in vlookup. We have
    > a
    > list of months and the corresponding days in the month. When someone
    > selects
    > the month from a drop down list, the appropriate number of days should be
    > returned from the vlookup. The lookup is returning the wrong number of
    > days
    > for the selected month.
    >
    > Example
    >
    > Drop down validation uses the months in column M. The drop down is in
    > cell
    > D1.
    >
    > Vlookup in F1 - VLOOKUP(D1,M8:N19,2)
    >
    > Col M Col N Rows 8-19
    > October 21
    > November 22
    > December 23
    > January 21
    > February 20
    > March 23
    > April 21
    > May 22
    > June 22
    > July 21
    > August 23
    > September 22
    >
    > As is, the vlookup returns 20 for July. Is there a way to fix the error.
    >
    > Thanks




  3. #3
    Dave O
    Guest

    Re: Vlookup will not reference a validation/drop down box

    Try changing the formula from VLOOKUP(D1,M8:N19,2) in F1 to
    VLOOKUP(D1,$M$8:$N$19,2) Without absolute cell references (the $
    signs) the relevant data range changes each time, and skews the output.


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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