#1
|
|||
|
|||
Extract matched values from a query list to new sheet or column
Hi.. I have a spreadsheet with a large amount of data that I would like to be able to query or run a script that would use another "list" as it's query source and if any matches are found output the finds to another sheet or another column in that sheet. Hopefully this made since, but there could have been an easier way to explain it. Thanks for any help! |
#2
|
||||
|
||||
Best attach a workbook with realistic data in…
|
#3
|
|||
|
|||
Reply with attached workbook
Hopefully I did this right.. the source sheet contains the serial numbers I'm querying and the Query sheet contains the serial numbers I'm looking for. Thank you.
|
#4
|
||||
|
||||
Code:
=FILTER(Source!A2:E27,ISNUMBER(MATCH(TRIM(Source!D2:D27),Query!A2:A24,0))) |
Tags |
excel 2019 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
VBA to identify alpha numeric values in a word document and create a list of those values | olson.jacob720 | Word VBA | 0 | 04-18-2022 10:44 AM |
Auto-Entering Values into a Column in a Table based on Value in Adjacent Column | nytvsh | Excel | 2 | 12-06-2021 12:33 AM |
Formula to check combinations of values in one column to find match from another column | kong1802 | Excel | 1 | 06-15-2018 05:26 AM |
Multiple found values from five sheets, multiple returned values in sheet six? | irisha | Excel Programming | 26 | 09-30-2016 01:20 AM |
Error: The Name Could Not be Matched to a Name in the Address List. | Shawn76 | Outlook | 0 | 04-07-2010 08:32 PM |