Lookup value from different lists and return different results

Hello,

Thanks for looking at my thread. I have attached a file here. I have the result on column R to T. I have 3 lookup lists on column A, C, E.

If column Rx = column A, then lookup value from column H to I, value 2, then

If column Rx = column C, then lookup value from column K to L, value 2, then

If column Sx = column E, then lookup value from column N to O, value 2

I hope I explain it well enough.

Thanks for the help.

Jackson