Check a value from another table exists in cell and return this value.

I have a column of data. I would like create formula which checks whether the site reference name exists and returns it:

Existing Column : Required Output
43VICTORIA 001225 REM : VICTORIA
41CHANCERY LANE GO 001361 REM : CHANCERY
43VICTORIA 001224 REM : VICTORIA
43VICTORIA 001223 REM : VICTORIA
41366 STRAND 000970 REM : STRAND
44CHEAPSIDE 001279 REM : CHEAPSIDE


I have a list of the site references:
VICTORIA
CHANCERY
STRAND
CHEAPSIDE

Can you please help me! I need a solution that does not use VBA.
Thanks
James

Assume your existing column starts in A1 and your output column starts in B1. Also assume your site references are in I1:I4.
Put this in B1 and drag down:
=INDEX($I$1:$I$4,SUMPRODUCT(NOT(ISERROR(FIND($I$1:$I$4,A1)))*ROW($A$1:$A$4)))