|re: "Either VBA code or a formula are fine with me."|
How about a combination of both, which is known as a User Defined Function (UDF)?
I am going to assume that Table 2 resides in Sheet2!A1:A3.
Press Alt-F11 to open the VBA editor
Under Insert, choose Module
In the pane that opens, paste in this code:
Function GetStore(ByVal target As Range)
For Each cell In Sheets(2).Range("A1:A3")
If target Like "*" & cell & "*" Then
GetStore = cell.Offset(0, 1)
If GetStore = "" Then GetStore = "Business Not Found"
Back in the sheet that holds Table 1, enter this in B1 and drag it down:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.