I hope this is also OK for MAC, but try the following
in the "test master" sheet in F4 enter
and pull down as needed
in the "test medical" one in C4 enter
Code:
=VLOOKUP(A4&B4,CHOOSE({1,2},'[test master.xlsx]Sheet1'!$F$4:$F$30,'[test master.xlsx]Sheet1'!$E$4:$E$30),2,0)
in D4
Code:
=VLOOKUP(A4&B4,CHOOSE({1,2},'[test master.xlsx]Sheet1'!$F$4:$F$30,'[test master.xlsx]Sheet1'!$C$4:$C$30),2,0)
and pull down as needed