place this on cell E2 aand fill it down =vlookup(a2,c$2:d$1000,2,0)
R Russ Jun 14, 2005 #2 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
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
