+ Reply to Thread
Results 1 to 4 of 4

Data validation error message when a VLOOKUP formula results in certain value

  1. 02-09-2015, 10:59 PM #1
    prodacct
    prodacct is offline
    Registered User
    Join Date
    02-09-2015
    Location
    California, United States
    MS-Off Ver
    MS Office 2010
    Posts
    5

    Data validation error message when a VLOOKUP formula results in certain value

    Hi everyone! I am hoping someone can help me with this problem. Is there a way to have an error message pop up through data validation when a cell with a vlookup formula returns a specific value.

    For example:

    I have a workbook with two tabs. Tab one is my master list of names with names in column one and column two is if there are missing documents in their file. In tab two (my daily working tab) I have a pull down list in which column one is a pull down from the list of names from the master tab. Column two is a vlookup formula to lookup the "missing documents" column from the master list after the name has been selected from the pull down list.

    Is there a way that once the name is selected from the drop down list and the vlookup formula has returned a specific value to have an error message pop up to let the inputter know there are documents missing.

    I have attached my test document as an example as well. I hope someone out there can help me out!! THANK YOU!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-09-2015, 11:05 PM #2
    GC Excel
    GC Excel is offline
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: Data validation error message when a VLOOKUP formula results in certain value

    Hi and welcome to the forum,

    The Popup message through data validation will not work with the formula.
    Suggestion:
    You can use conditional formatting to highlight the cells = YES in red.

    Or else, add this formula in C2 :

    Please Login or Register  to view this content.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
    Reply With QuoteRegister To Reply
  3. 02-09-2015, 11:14 PM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Data validation error message when a VLOOKUP formula results in certain value

    Hi, welcome to the forum

    Rather than DV, which is generally use to make sure data entry is correct (it works on what is entered into a cell, not what already exists in the cell), I suggest you use Conditional Formatting to make the cell change color

    If you are not familiar with CF...

    1. highlight the range you want to apply the conditional formatting to
    2. on the home tab, styles, select CF
    3. select Format Cells That Contain
    4. Select Specific Text and enter Yes
    Format fill as required
    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
    Reply With QuoteRegister To Reply
  4. 02-09-2015, 11:16 PM #4
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Data validation error message when a VLOOKUP formula results in certain value

    Using conditional formatting in another way....set =B1="Yes"...set the color....then set Number format to Custom @ "Documents are missing"

    File attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combining a data validation list with a custom formula (including error message)
    By robgron in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2014, 07:23 AM
  2. Combining a data validation list with a custom formula (including error message)
    By robgron in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-16-2014, 09:55 AM
  3. [SOLVED] Using results of a VLookup formula in Data Validation to generate a list
    By JessicaJG in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-13-2013, 03:52 PM
  4. Data Validation Error Message
    By Blake 7 in forum Excel General
    Replies: 11
    Last Post: 11-28-2010, 01:52 PM
  5. Error Message with Data Validation
    By Chet Hurd in forum Excel General
    Replies: 2
    Last Post: 06-09-2005, 04:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1