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
|