G
Guest
Say I have two columns entered on worksheet 1.
Model Pwr
DL 360 180
DL 385 260
ML 375 300
MSA 30 400
On a different worksheet, or within the same worksheet, I want to be able to
type in a cell the Model, and have it search the Model column, and if it
finds identical entry, copy the value in Pwr column to the cell next to it.
Like in cell K1 I enter DL 385, and it will automatically copy 260 to cell L2.
Is this possible? Thanks.
Model Pwr
DL 360 180
DL 385 260
ML 375 300
MSA 30 400
On a different worksheet, or within the same worksheet, I want to be able to
type in a cell the Model, and have it search the Model column, and if it
finds identical entry, copy the value in Pwr column to the cell next to it.
Like in cell K1 I enter DL 385, and it will automatically copy 260 to cell L2.
Is this possible? Thanks.