I can't seem to find the right formula for this formula.

A2:A100 = product code
B2:B100 = price (level 3)
C2:C100 = price (level 2)
D2:D100 = price (level 1)

If I enter a product code in cell E1 and enter "Level 3" in cell F1, I want
the formula in cell G1 to tell me what the price of that product is in the
column B for that level.

I hope this makes sense and someone can help me as I know I have used this
before.

Thanks!

Annette