Dependent drop downs

Hello,
I'm using Office 2016 and I've already set up the attached sheet so that you select the carrier and the audit type from drop downs and that works well. Now I want to add the auditor's extension and shift hours which are located on the tab called drop downs. Im having a tough time figuring out how to make it work.

I've tried these two equations without success

IF(OR(F6="Allen", "227/127, f6="Bud", "235/135", f6="Chris", "147", f6="Doug", "237/137", f6="Maria", "232/132", f6="Mike", "108", f6="Shaun", "234/134", f6="Steve", "212/112", f6="Alfonse", "202/102", ""))
or
IF(F6="Allen", "227/127, f6="Bud", "235/135", f6="Chris", "147", f6="Doug", "237/137", f6="Maria", "232/132", f6="Mike", "108", f6="Shaun", "234/134", f6="Steve", "212/112", f6="Alfonse", "202/102", "")

I am fine with either pulling the data from the drop down tab or just entering it as strings as above. Can anyone help? Thank you in advance

Wow! That works great! Thank you!