+ Reply to Thread
Results 1 to 5 of 5

Lookup in a Data Validation List

  1. #1
    Forum Contributor
    Join Date
    02-20-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2013
    Posts
    108

    Lookup in a Data Validation List

    Hi all, Im generally good at working these things out but im stumped on this one.

    I have a data list in cell A1 on sheet one, returning a list of employee names

    On sheet 2 all the names are lined out horizontally with 3 rows of info under each name

    So i would like to create a second drop down list on sheet 1 cell A2 that will look at the value in A1 (employee name) and look for that value in sheet 2, and return a drop down list with the 3 pieces of information located under that name in sheet 2.

    I've been trying a few things such as lookup and if functions and seem to have completely confused myself.

    any more info or if you need an example let me know

    Any help be great

    Regards,
    Simon

  2. #2
    Forum Contributor
    Join Date
    12-09-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    171

    Re: Lookup in a Data Validation List

    Hi,

    Use the following formula

    =INDIRECT(HLOOKUP($A$1,Sheet2!1:3,2,0))
    Like my answer, then click * below

  3. #3
    Forum Contributor
    Join Date
    12-09-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    171

    Re: Lookup in a Data Validation List

    If still, your problem is not solved. Kindly help with an example file...

  4. #4
    Forum Contributor
    Join Date
    02-20-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2013
    Posts
    108

    Re: Lookup in a Data Validation List

    Hi satabp,

    Thanks for your quick reply

    I have tried this and similar formulas but keeps returning the error

    "The Source evaluates to an error, do you want to continue" which i do but returns a single blank selection in the list

    Seems like it should be a simple problem to fix, yet has me stumped

    Please find attached a simplified version of my document as the original contains sensitive information.

    Be great if you could have a look

    Regards,
    Simon
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    12-09-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    171

    Re: Lookup in a Data Validation List

    Oh, I missed to say, that all the ranges should be named. Then lookup using the indirect

+ 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. [SOLVED] Multiple Result Lookup inside Data Validation List
    By Whizbang in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-13-2014, 12:53 PM
  2. 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
  3. 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
  4. Excel 2007 : Validation list lookup
    By rock755 in forum Excel General
    Replies: 5
    Last Post: 08-08-2010, 07:37 PM
  5. 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

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