+ Reply to Thread
Results 1 to 7 of 7

Lookup based on data validation list

  1. #1
    Registered User
    Join Date
    04-30-2019
    Location
    Stoke-on-Trent, England
    MS-Off Ver
    2016
    Posts
    18

    Lookup based on data validation list

    Hi

    I need some help with a formula to return the word TRUE in a cell on sheet2 when I change a drop down list. all the info is in a table on sheet1

    for example on

    Sheet1
    Name Qualification 01 Qualification 02 Qualification 03 Qualification 04
    Name 01 Y Y
    Name 02 Y Y
    Name 03 Y
    Name 03 Y

    Then on Sheet 2 I would have the Data validation at the top and when i select Qualifaction 1 it would return the below result

    Name Qualification Match
    Name 01 TRUE
    Name 02 TRUE
    Name 03 TRUE
    Name 03



    example workbook is attached, not sure how explain further.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    503

    Re: Lookup based on data validation list

    Hi, check formula in A4 and copy down
    Please Login or Register  to view this content.
    Greetings.

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,035

    Re: Lookup based on data validation list

    Another option
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    04-30-2019
    Location
    Stoke-on-Trent, England
    MS-Off Ver
    2016
    Posts
    18

    Re: Lookup based on data validation list

    Hi

    I couldn't get the top formula t work but got the 2nd one working great, changed to match my workbook and got the output to display the qualification

    Please Login or Register  to view this content.
    But I have had to change the original Staff page now for some qulaifications in the box it will have a "Y" but for others it will have a date where the qual/license runs out and I can't figure how to change the formula to match.

    I have included a new spreadsheet (attached)
    Attached Files Attached Files

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,035

    Re: Lookup based on data validation list

    If you just want it to return a value if the cell is not empty, use
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    04-30-2019
    Location
    Stoke-on-Trent, England
    MS-Off Ver
    2016
    Posts
    18

    Re: Lookup based on data validation list

    Thank you that worked, I think I had been looking at it too long and not noticed how obvious that was

    So thank you both Fluff13 & maras_mak

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,035

    Re: Lookup based on data validation list

    You're welcome & 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. Data Validation List Associated with a Cell Value Lookup
    By kishoremcp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-29-2018, 02:15 PM
  2. Replies: 1
    Last Post: 01-14-2018, 11:04 AM
  3. Lookup in a Data Validation List
    By Simon.xlsx in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-28-2014, 09:23 AM
  4. Create data validation based on lookup to get a list
    By Rocky2013 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-16-2013, 11:31 AM
  5. VBA for variable lookup from data validation list
    By Ravenous in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-15-2013, 01:03 AM
  6. Replies: 3
    Last Post: 04-11-2011, 05:52 PM
  7. Lookup Value based off Data Validation List / Populate Form
    By snake10 in forum Excel - New Users/Basics
    Replies: 13
    Last Post: 03-22-2009, 02:57 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