Need to return a Y/N-style result on a filtered/importrange list from various inputs

Ok, here we go. I'm working in Google Sheets for the final project, so not sure how much this will be affected by that. But here's the concept:

Sheet 1: Master Data 1
Column C: Last Names (C3:C)
Column J: Branch (only two possible values, Navy or USMC)

Sheet 2: Output Roster
Column B: Last Names (filtered->importrange list from Sheet 1)
Column C: Branch ***THIS IS WHERE WORK IS NEEDED***

I want to have Column C next to each person's last name displayed from the filter->importrange to then show their respective service by a one-letter code of either N or M, based on Master Data 1's Column J values.

Here is my stab at your request (see attachment)

Please Login or Register  to view this content.

Formula requires you to press Shift + Ctrl + Enter

On the Master Data 1 sheet I placed an if statement in column K which places a N if cell in column J equals Navy or place a "M" if cell equals USMC

Please Login or Register  to view this content.

You could also do without column K within the Master Data 1 sheet and just use

Please Login or Register  to view this content.