Multiple input values to be matched to return from a single list

Dear All,

Below is the requirement:

Crank shaft
Bearing journal - Main
Bearing journal - Rear
Intermediate bearing journal
Crank pin journal
Crank gear
Counterweights
Throw - Front
Throw - Rear


Assume this list in column A & the parameters will change randomly within the column. As & when the parameters change I need a solution which involves MATCH function.

I will elaborate the requirement.

Now assume E1 = Crankshaft; E2 = Crankgear

In a single formula, I need MATCH function to check for both E1 & E2 at the same time in the column A. The value which matches with the text string should return accordingly in column B i.e in the present case, 1 in B1 & 6 in B6. When the Crankshaft & Crankgear cell location change within column A, corresponding value needs to be returned in Column B. This should occur with a single formula only which I am emphasizing over & over (sorry for being repetitive & if it is sounding rude / arrogant).

I tried this formula in Column B:
=MATCH(OR($E1,$E2),$A$1:$A$9,0)
MATCH function is simultaneously looking for either of the inputs in the array to return the corresponding value (trying to look for E1 or E2 & return the value in Column B for individual matches). However, this is returning an error.

I hope above defined problem is comprehensible now. If there is a solution then it will be extremely helpful for me.

Thanks in advance.

P.S - The list which is existing is really huge.

- Billy