Return multiple values for multiple criterias

Hi,

I am having a list of samples as in 'D' and want to return values as in 'E' with criteria as in the 'A' and 'B' columns. The criteria suggest that, if there is 'r' in the text then return 'RBCL-F'. Following is the formula that works if the text doesn't have similar text, but if I am having similar text. So, I am getting the wrong values (as in E4).

Please Login or Register  to view this content.

For this, I think

Please Login or Register  to view this content.

must be integrated somewhere in the formula, so that it considers only the first letter. Pls, assist, with how it can be done?

A	B
r	RBCL-F
m	MATK-F

D	E
rASBT1	RBCL-F
mASBT2	MATK-F
rASBM4	it should return "RBCL-F", but as it has M, the formula is returning "MATK-F

Which version of Excel do you have? Please update your profile to make this clear: Is it Excel 16 for Mac or Excel 2016?

There are instructions at the top of the page explaining how to attach your sample workbook.

Great. No sample workbook, though ... Waiting for that.

It's as simple as this (I think):

=IFERROR(VLOOKUP(LEFT(D2,1),$A$2:$B$3,2,0),"")

What am I missing?