It would greatly help if you upload a sample file with realistic data, the solution will be close to what you are looking for. please provide expected results too for few rows so that formula can be tested. thank you !!
Perhaps, you are looking for something like that in the attached file. There are drop-down lists in Columns F and H for TraderName and ContractType, respectively. The formula in I2, copied down rows, is:
=VLOOKUP(F2, A$2:D$4, MATCH(H2,A$1:D$1,0),0)
Conversly, the formula in J2, copied down rows, is: