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

[Niraj1]

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.

[#2 · Accepted solution]

@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.

[#3]

@Niraj1 

If you don't have FILTER() function you may add helper column with COUNTIF as inside of @Peter Bartholomew formula and filter on this column excluding zeroes.