+ Reply to Thread
Results 1 to 3 of 3

Formula to Pull the list based on a particular value

  1. 08-17-2020, 10:36 AM #1
    GemBox
    GemBox is offline
    Forum Contributor
    Join Date
    04-18-2016
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    178

    Formula to Pull the list based on a particular value

    Hi All,

    I have a requirement to pull down the data from another sheet with reference to one value. Please refer the attachment for more details.

    Regards,
    Gem
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-17-2020, 11:21 AM #2
    Haluk
    Haluk is offline
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,147

    Re: Formula to Pull the list based on a particular value

    You can try the attached file, where I've done small changes in your sheet "Requirement" and sorted your table in sheet "Data"
    Attached Files Attached Files
    Last edited by Haluk; 08-17-2020 at 11:47 AM.
    Reply With QuoteRegister To Reply
  3. 08-17-2020, 12:59 PM #3
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Formula to Pull the list based on a particular value

    Why not just filter on column B (25 mm) in the original sheet?

    See the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    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. Formula or Method to Pull list of items based on a Group?
    By SaitoGT in forum Excel General
    Replies: 1
    Last Post: 12-04-2019, 09:27 AM
  2. Formula to pull from list based on date
    By awascholl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-06-2019, 06:00 PM
  3. Array Formula to Pull List Based on Date - #NUM! Error
    By wooshoe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-30-2019, 08:41 AM
  4. [SOLVED] Auto Fill Cells based on pull down List
    By SavageMind in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2012, 06:50 AM
  5. Pull data from list based on certain criteria
    By JakeD in forum Excel General
    Replies: 1
    Last Post: 11-15-2011, 11:47 PM
  6. Pull from list based on number of orders
    By cshort in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2011, 11:22 AM
  7. Pull from list based on multiple criteria
    By chitownsox14 in forum Excel General
    Replies: 3
    Last Post: 04-20-2011, 12:12 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