Forum Discussion

Niraj1's avatar
Niraj1
Copper Contributor
Jun 05, 2021
Solved

Excel : Search for data in an excel data file from another excel file having the list of items

I have two excel files. One file has a complete data. Another excel file has a list of items. I want to look for the items in data file, which are from the list in another file.  
  • PeterBartholomew1's avatar
    Jun 05, 2021

    Niraj1 

    You need to test each record within the data file to determine whether it meets the conditions set by the list.

    = FILTER(data, COUNTIFS(extract, complete))

    where 'extract' is the list of records to return and 'complete' is the corresponding field in the source 'data'. 

    Note: FILTER is an Excel 365 function.

Resources