+ Reply to Thread
Results 1 to 4 of 4

Find multiple values

  1. #1
    Registered User
    Join Date
    02-25-2021
    Location
    Dubai
    MS-Off Ver
    365
    Posts
    2

    Exclamation Find multiple values

    Hi,

    I have a huge excel sheet (around 4000 entries) and need to find specific, staff in the list (about 1200 unique staff IDs).

    I really don't want to have to type in 1200, individual staff IDs in the "Find" tool.

    HELP!! What tool can I use to find them all?

    Thanks guys

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,912

    Re: Find multiple values

    Please Login or Register  to view this content.
    Try this new formula
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Registered User
    Join Date
    02-25-2021
    Location
    Dubai
    MS-Off Ver
    365
    Posts
    2

    Re: Find multiple values

    Thanks for your suggestion. Unfortunately, the numbers do not follow a numerical order, so a range won't work, e.g A1:A4000. I have them in a separate list. I'm hoping there's a way I can paste them all into a formula that will find them for me...

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,912

    Re: Find multiple values

    Look at this sample
    Attached Files Attached Files

+ 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. Issue loading values using vba to find values on multiple sheets
    By asianqueen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2019, 12:40 AM
  2. [SOLVED] Macro to Find and Replace Multiple Values Across Multiple Sheets
    By MattyD123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-09-2018, 10:44 PM
  3. Replies: 2
    Last Post: 05-26-2015, 07:29 PM
  4. Find multiple values in multiple ranges and produce results in a list
    By Sc0tt1e in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2014, 02:11 AM
  5. [SOLVED] Faster way to find and replace multiple values with corresponding values
    By babbeleme1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-18-2013, 06:50 PM
  6. How to find closest values in multiple columns and return adjacent values.
    By Patrician in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-28-2013, 01:47 PM
  7. Find and Replace values from multiple lookup values
    By Gregula82 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2007, 03:12 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