IF and SEARCH, or FIND fuctions together?

I am working with photos that are being uploaded to a share point site and am attempting to build a spreadsheet that will populate the metadata fields automatically based on the title of the photo. I have uploaded a sample of what I am trying to accomplish.

The naming conventions have a few possibilities which is throwing me off. You will see in sheet 2 of my attachment what the acronyms stand for.

Thank you, thank you, thank you in advance, this has been driving me crazy for a couple days and I know there is a way to do it, I just can't get it.

B