Return Value from 2nd column when value in 1st column matches given criteria

I have a column containing text values eg M1, T2, M3, A4 etc. and I am trying to return the value (numeric) in a second column to a cell when the text value in the first column is matched.

I'd appreciate any help with this.

Thanks.

COLUMN 1 contains M1 T2 M3 M4 T5
COLUMN 2 contains 2 3 1 0 5

The data is something like that dewscribed above.

In a separate cell, I am trying to build a function that finds, for example, the value of M3 in Column 1 and then returns the value in the same row of Column 2. In this example, it would return the value 1.

I hope this clarifies.