Searching cell for text in specific location and pasting result in another cell

I have a sheet that contains model names and model numbers. I need to loop through each row and do the following:

If model name in column a is "Orange" and the tenth digit in column b is "5" then enter "Model 1" in column c

or if model name in column a is "Apple" and the sixth digit in column b is "C" and the tenth digit in column b is "5" then enter "Model 2" in column c

This can be done with a formula. In cell C3, paste this:

Please Login or Register  to view this content.

copy/autofill down.

Try this:

Please Login or Register  to view this content.