Searching through array of elements

I've got a small issue with my Excel formula.

In one column I have random strings and the other one is used to standardize the inputs:

Column1
Administrator 
Apples 
Apple juice
Orange
Computer device
Lookup column:
Admin
Apple
Orange 
Computer

The preferred output would be:

OUTPUT
Admin
Apple
Apple
Orange
Computer

So, basically I want to use xlookup function to go through all elements from lookup array and return the lookup version of the text. I tried using "" &[lookup array] & "". The function spills so that is no more a good solution for me.

Any help would be greatly appreciated

I tried using search function as well but this one also spills and I'm not sure if I need extra function to reduce the result to one cell or maybe I need completely different function.

Try this one.

=XLOOKUP(
    TRUE;
    ISNUMBER(SEARCH(TRIM(LookupColumn); String1));
    LookupColumn;
    "No matches"
)

EDIT: Changed references to better match the OP example data