Not sure which formula (PIVOT, MATCH, FIND, e.t.c)......

This ARRAY formula will do what you want...
=IFERROR(INDEX(Op_Exp_Mode_function!A$2:A$3000,SMALL(IF((Op_Exp_Mode_function!$G$2:$G$3000="MB")*(Op_Exp_Mode_function!$H$2:$H$3000="DO"),ROW($A$2:$A$3000)-2),ROWS($A$1:A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
You change the hard-coded MB and DO to cell references, and enter your dcelection there

However, if you really have a lot of data, ot may start to slow things down, so a PT may work for you

No need to upload teh file. Put that in sheet3 A2, using CTRL SHIFT ENTER, then copy down and across

You can do what you want by using the Advanced Filter found on the Data tab.
You already have copied the column headers to Sheet3.
Enter MB and DO in columns G and H respectively.

With Sheet3 the active worksheet, click on the Filter tab, Advanced filter.
Click on Copy to another location. Click in the List Range field and select the data including the headers on the Op_Exp_Mode_function worksheet.
In the Criteria Range select the Headers and criteria on Sheet3 (A1:I2)
In the Copy to enter A5 and click OK.

All the records from Op_Exp_Mode_function that match MB DO will be filtered onto Sheet3.

I added 4 columns to ALL DATA for MBDO MBPT DRDO DRPT (columns V,W,X,Y) with this formula entered in 'ALL DATA'!V4 and filled down:

Formula:

Please Login or Register  to view this content.

The MB and DO were changed to MB and PT, DR and DO, and DR an PT as appropriate in columns W, X and Y.
This formula was then entered in 'VOMS by MODES'!E4 and filled across and down:

Formula:

Please Login or Register  to view this content.

Thank you for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.