Using the SEARCH function with mulitple criteria against one cell

[Excel_VBA]

Column A called Transactions which contain the following:
OUTBACK #8740 CHANTILLY VA
TROPICAL SMOOTHIE VA85 HERNDON VA
FLIPPIN PIZZA CHANTILLY VA

Column C called Lookup List has:
OUTBACK
TROPICAL SMOOTHIE
CHARLIE CHAING'S REST
BACKYARD GRILL
FLIPPIN PIZZA

All of these values line up on the same row starting with row #2. In column B, I am trying to figure out a formula which will pick up all values in column C, then use the SEARCH function on those values and look to the value in column A and see if one of the search values in column C appears in column A.

For example, in cell B2, I want to have a formula that considers all lookup values in column C, then look to cell A2 which has "OUTBACK #8740 CHANTILLY VA" and if OUTBACK appears in cell A2 (which it does), then the position number of OUTBACK would be returned.

I suppose an array formula is needed. I was trying to do something like:
=SEARCH(C2:C22,A2,1)

I get the #VALUE! error. I tried pressing Enter as well as Ctrl + Shift + Enter and I still get the same error.