Hi to everyone,


I have a small table 6 x 2, and i have to find a data inside this matrix.
I need a formula that reads two criterias:

In cell E12 i have the first column and that's the first criteria
In cell F12 I have a formula IF that gives me a YES or No by this result i have to pick one of the two colums


Market INF to 2yrs SUP to 2 yrs market Inf 2yrs Sup 2 yrs
MOT(E12) NO(F12) SI MOT 0.35% 0.50%
EUROMOT 0.35% 0.50%
EXTRAMOT 0.50% 0.70%
TLX 0.50% 0.70%
HI-MTF 0.50% 0.70%
OTC 0.70% 1.00%

Can somebody pls help me because i have tried many solutions but i am not getting anywhere