Forum Discussion
Breach or not breach result using IF Function
Hi, Can anyone help to get result breach or not breach for the below condition Trader A limit = 600 for USD/AED and 800 for Other CCY Trader B limit = 700 for USD/AED and 600 for Other CCY Trade...
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")