Jul 30 2019 09:43 PM
Jul 30 2019 09:48 PM
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 !!
Jul 30 2019 10:47 PM
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:
=IF(G2>=I2,
"Yes",
"No")