Hey all - could use a hand with a formula that I just can't seem to get working. Unfortunately, I cannot use VBA to solve this one.

Spreadsheet (attached) has 2 columns - ShortName and LongName

Need a formula that will find any instance of each short name in the LongName Column, and put that shortname in the adjacent column.

So if Shortname list has "Edgewood" and any cell in the LongName column has "Barnaby Heights, Edgewood, Salvador", the adjacent cell in column C should just read "Edgewood"
Hopefully the attachment will make it clearer than I can describe here.

Thanks for any help!