+ Reply to Thread
Results 1 to 6 of 6

Data Validation List that matches Field Heading of Target Cell with Source Heading

  1. #1
    Registered User
    Join Date
    07-25-2016
    Location
    India
    MS-Off Ver
    2016
    Posts
    3

    Data Validation List that matches Field Heading of Target Cell with Source Heading

    Hello All,
    I have taken help of this forum multiple times through google searches, but this time around the problem seems too big for me.

    I have multiple excel files where one sheet contains all data arranged in columns and one another sheet where dropdown list needs to be created.

    Now, the column headings of both source and target are the same and I need to create a dropdown list where the formula automatically picks up data from the source depending on this name.

    I have tried various things like copying data from source file and pasting it in proper arrangement (source and target have different column arrangements) using hlookup. But this resulted in too many blank fields that I could not get rid of.

    I open to follow any method as long as it saves time for me. So, is it possible to achieve something of this sort? If yes, please guide me in that direction.

    Thank You!

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Data Validation List that matches Field Heading of Target Cell with Source Heading

    Pl upload a sample file.

  3. #3
    Registered User
    Join Date
    07-25-2016
    Location
    India
    MS-Off Ver
    2016
    Posts
    3

    Re: Data Validation List that matches Field Heading of Target Cell with Source Heading

    Hi kvsrinivasamurthy,
    Thanks for replying. Here is the sample file.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Data Validation List that matches Field Heading of Target Cell with Source Heading


  5. #5
    Registered User
    Join Date
    07-25-2016
    Location
    India
    MS-Off Ver
    2016
    Posts
    3

    Re: Data Validation List that matches Field Heading of Target Cell with Source Heading

    Hi JohnTopley,
    I have gone through this page before, I think. However, I don't need a dependent list. Ideally, I would like a formula which I can paste instead of range while making dropdown list.

    That formula should match column headings and fetch the range automatically.

    Is it possible?

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Data Validation List that matches Field Heading of Target Cell with Source Heading

    Not sure still but as an example.

    Named range called "Color"

    Refers to: =OFFSET('Accepted Values'!$E$2,,,COUNTA('Accepted Values'!$E:$E)-1,1)

    In AH in "Accessories"

    Data Validation

    Allow: List

    Source: =Color

    If this what you require repeat for other headings.

    Note if a Heading has space e.g. "Bike Make", then the named Range will be "Bike_Make"

+ 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] Determine if heading is within range of +-15 of another heading
    By magnus.blomquist in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-06-2016, 12:16 PM
  2. Replies: 0
    Last Post: 10-25-2014, 11:28 AM
  3. [SOLVED] Look for a certain heading but if not found then move to next heading you are after.
    By Steve2107 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-03-2014, 03:02 AM
  4. [SOLVED] Pulling out data from different worksheet when changing a heading on the top-down list
    By jjin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-02-2013, 02:41 AM
  5. [SOLVED] Copy and Paste a specific Column to a Column that's heading matches a particular cell
    By Rexmond in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2012, 12:29 AM
  6. [SOLVED] Sub-heading stuck at same heading number
    By Hallet in forum Word Formatting & General
    Replies: 1
    Last Post: 06-01-2012, 08:16 AM
  7. In a table produce an value by column heading and row heading
    By naflan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-27-2005, 01:25 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