If function formula

[Leopold2000]

Hi,

Quite difficult to explain this one...

I am looking for an 'if' function formula that says if the value in COLUMN C is equal to a value in COLUMN A, then put the value of COLUMN B which is in the same ROW as the matched value in column A in column E. Below is the table and I have attached the excel too. Would greatly appreciate any help!

A B C E D

# Price # (Formula should bring up)
1 10 1 10
2 12 2 12
3 14 3 14
4 16 1 10
5 18 1 10
6 20 7 22
7 22 6 20

Thanks,

Leopold2000