Results 1 to 7 of 7

Data validation and Vlookup issues

Threaded View

scottwhittaker2333 Data validation and Vlookup... 06-03-2010, 09:37 AM
NBVC Re: Data validation and... 06-03-2010, 09:39 AM
scottwhittaker2333 Re: Data validation and... 06-03-2010, 09:47 AM
NBVC Re: Data validation and... 06-03-2010, 09:50 AM
scottwhittaker2333 Re: Data validation and... 06-04-2010, 11:23 AM
NBVC Re: Data validation and... 06-04-2010, 12:04 PM
scottwhittaker2333 Re: Data validation and... 06-05-2010, 11:41 AM
  1. #1
    Registered User
    Join Date
    06-02-2010
    Location
    Grand Rapids, Michigan
    MS-Off Ver
    Excel 2003
    Posts
    64

    Unhappy Data validation and Vlookup issues

    This thread is solved!!I'm not really sure why but every time I use data validation to create a drop down and then vlookup in another cell to change to matching data based on whats in the drop down form the vlookup SearchCriterion it never seems to pull up the correct reference data. As a way around it I have found that if I make sure the dropdown box or the vlookup cell are not selected and then autofilter the SearchCriterion area and sort it assending that it usualy works after that, but I'm pretty sure that I shouldn't have to do that. Is there something wrong with the way that I have the formula? Here is what I have:

    Cell R14 contains the dropdown.
    Cell Q21 contains this formula: =IF(ISBLANK(R14);"";VLOOKUP(R14;A130:D220;2))
    Cell O21 contains this formula "=IF(ISBLANK(R14);"";VLOOKUP(R14;A130:D220;3))
    Last edited by scottwhittaker2333; 06-05-2010 at 11:37 AM. Reason: This post is solved

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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