| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up a value in one column and give a corresponding value
I want to use the value in one cell e.g. RL8-CC1 to provide the matching
value in a different colun in the same row. e.g. RL8-CC1 is in cell D:24 and the lookup value I am after is Repair Line 8 - Chain Conveyor 1 which is in cell E:24 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Look up a value in one column and give a corresponding value
try
Vlookup("RL8-CC1",D1:E100,2,False) "Argyle" wrote: I want to use the value in one cell e.g. RL8-CC1 to provide the matching value in a different colun in the same row. e.g. RL8-CC1 is in cell D:24 and the lookup value I am after is Repair Line 8 - Chain Conveyor 1 which is in cell E:24 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
| Need a formula to give me the last value in a column. | Excel Worksheet Functions | |||
| Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
| How can give the same name to a row or column in different sheets. | Excel Discussion (Misc queries) | |||
| calculate which cells in column A will give me the total of column | Excel Worksheet Functions | |||
Hybrid Mode
