ExcelBanter - Look up a value in one column and give a corresponding value

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Look up a value in one column and give a corresponding value (https://www.excelbanter.com/excel-discussion-misc-queries/189599-look-up-value-one-column-give-corresponding-value.html)

Argyle

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

TUNGANA KURMA RAJU

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

All times are GMT +1. The time now is 12:40 PM.