wMicorsoft Office Excel 2003
I need to look up an answer from a column based on another column and place
the answer in yet another column. See example

Col A Col B Col C Col D Col E (the answer)
Apple 20 Orange 5 35
Orange 10 Apple 35 5
Search Col C based on Col A and return answer to Col E from Col D