Extract matched values from a query list to new sheet or column

wlarkin · #1 06-09-2023, 10:02 AM

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!

p45cal · #2 06-09-2023, 10:53 AM

Best attach a workbook with realistic data in…

wlarkin · #3 06-09-2023, 11:30 AM

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.

p45cal · #4 06-11-2023, 04:42 AM

Code:

=FILTER(Source!A2:E27,ISNUMBER(MATCH(TRIM(Source!D2:D27),Query!A2:A24,0)))

In any cell/sheet in the same workbook.

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