Hi,

I'm stuck on how to get search one array with another array and get the matching result of the two arrays:

Array 1, A1:C1;
Bob
Bill
Ben

Array 2, E1:E3;
Luke
Ben
Han

In D1 I should have the result: Ben

Any help would be greatly appreciated.