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

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Extract matched values from a query list to new sheet or column

06-11-2023, 04:42 AM

p45cal

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

Office 2021

Expert

Join Date: Apr 2014

Posts: 962

Code:

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

In any cell/sheet in the same workbook.

Tags

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:00 PM.