Forum Discussion
parky_pilot
Dec 17, 2022Copper Contributor
find entries common in two lists
how do you find entries common in two lists in excel 365?
dscheikey
Dec 17, 2022Bronze Contributor
For example, with the MATCH() function. Here is the syntax: =XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])