You can use INDEX/MATCH formulation:
e.g.
In A8 of your front end sheet, enter formula:
=INDEX('Master'!$A:$F,MATCH($A$5,'Master'!$A:$A,0) ,MATCH(A7,'Master'!$A$1:$F$1,0))
You may have to replace the F column references to suit your Master sheet as we can't see from your images how far the sheet extends.
for the other cells in the frontend sheet, you just need to change the A7 reference to suit the profession you are looking for in row 1 of Master sheet.
|