excel vlookup

[Rising Flight]

Hi All

i have a sheet1 and sheet2 , i want to compare sheet2 with sheet1 and get the matching entries and put in sheet3

For example

Sheet1--i have columns A, B,C, D

 Sheet2- i have column A

I want to compare Sheet2 Column A entries with Sheet1 Column C entries and get the matching entries and put it in sheet 3 as in below screenshot i.e user2 and user6 is matching though user1 is not matching but user 2 is matching in Row1, any matching entry. experts guide me

 

[#2]

@Rising Flight 

As variant

=FILTER( data, COUNTIFS( userName, "*" & users & "*" ) )