+ Reply to Thread
Results 1 to 9 of 9

Search multiple values against list

Hybrid View

  1. 10-21-2024, 09:54 AM #1
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,317

    Re: Search multiple values against list

    Probably.


    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  2. 10-21-2024, 10:03 AM #2
    kosh67
    kosh67 is offline
    Registered User
    Join Date
    08-30-2022
    Location
    Scotland
    MS-Off Ver
    2022
    Posts
    26

    Re: Search multiple values against list

    Hi,

    understood, i've put together a mock document with 2 tabs.

    Basically looking for a way to search all the items on sheet one against the master list tab and pull the data from the master tab together so i'm only finding the data on those numbers.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 10-21-2024, 10:27 AM #3
    JohnTopley
    JohnTopley is offline
    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
    30,824

    Re: Search multiple values against list

    Master List has no data that appears on Sheet1 (e.g Description)
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  4. 10-21-2024, 10:32 AM #4
    kosh67
    kosh67 is offline
    Registered User
    Join Date
    08-30-2022
    Location
    Scotland
    MS-Off Ver
    2022
    Posts
    26

    Re: Search multiple values against list

    Hi John,

    only the item no's that i need to pull and those match the list, is that an issue?
    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. [SOLVED] Is there a cool way to search a list of values in multiple spreadsheets under an Excel
    By mls_newbee in forum Excel General
    Replies: 5
    Last Post: 04-17-2024, 04:18 PM
  2. Search a list with multiple values
    By mm82 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-08-2023, 11:12 AM
  3. Search and list values and adjacent columns from multiple workbooks
    By Petijandro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2021, 04:21 AM
  4. Search list and return multiple values
    By MarVil85 in forum Excel General
    Replies: 1
    Last Post: 06-23-2012, 03:46 PM
  5. Search Multiple Worksheets Against List of Non-Exact Search Criteria?
    By thump4r in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2010, 03:46 PM
  6. Search and list multiple values
    By skywalkman2007 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-28-2008, 02: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