Return Value Based On Partial Text String

I'm trying to figure out how I can return a value based on the first 2 letters in a cell to the left of it. For example:

Column A:
APAWOEFIN
MILCNAK123
DEAFEAWAP
MIAWEFNAP

Column B (RESULT):
APPLE
MICROSOFT
DELL
MICROSOFT

Logic: AP=APPLE, MI=MICROSOFT, DE=DELL. Tt can only look at the first 2 letters of the string or else the results will be off. Thoughts?

If there are just three, this if formula will work just fine
=IF(LEFT(A1,2)="MI","microsoft",IF(LEFT(A1,2)="AP","apple",IF(LEFT(A1,2)="DE","DeLL","")))

Sorry for the double post, I thought this formula would do the trick but it seems to be returning the wrong value sometimes. Like if more than one of the qualifiers is present in the text string it will return the result for the second qualifier instead of the first one that is the first 2 characters of the string, even though I put the LEFT({"AP","MI","DE"}, 2) in there. Any ideas?

Please Login or Register  to view this content.

Lol, ok I realized the LEFT() function has to be around the "A1" not the SEARCH() string. The correct function would be:

Please Login or Register  to view this content.

Solved.

Why would you not use my formula?
Your formula only uses three as well.
Here are three options
One uses vlookup