yogi_Extract 1st Preference Information From (row 3) 'Roster' For All Applicable Entries In Roster!B4:B

Google Spreadsheet   Post  #2544

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-17-2018

question by: Cody TimQuinn:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/obbPwcB_2a4;context-place=forum/docs

Trying to lookup multiple cell variables?
I'm looking to search for someone's name and their preferred 1st role, I'm not sure if I'm explaining this well haha. 

I would be looking for their name, finding their 1st pref. and determining what role that is

Cat's 1st pref. would be ADC