| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
Column Lookup
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
| Auto Skipping and protected cells | Excel Discussion (Misc queries) | |||
| Lookup last in column formulas | Excel Discussion (Misc queries) | |||
| How to lookup data in a row and column | Excel Discussion (Misc queries) | |||
Linear Mode
