place this on cell E2 aand fill it down
=vlookup(a2,c$2:d$1000,2,0)

"Russ" wrote in message
...
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