Formula that functions is based on what text is in a cell and I need a Macro for this.

I need a macro that will:
-take a column of cells in excel file(A), check it against a table in a another excel file(B)
-if cell in (A) matches a cell in (B), then do the formula that is stored in the next cell of excel file(B) inside the next cell of (A) and then repeat for all filled cell in (A).
----also how do I store a formula in a cell that can be used in another file? is there a better way to store the formula?


For the match, I need it to match a cell even if there is or is not a hyphen in the text.
For example: "SOD323" should match with the Cell that contains "SOD-323" or "SOD323" but not anything else.
Also:"SOT23-3" should match with the Cell that contains "SOT23-3" or "SOT-23-3" but not anything else.