When data match, copy adjacent value to adjacent column
Great! Awesome! Thank you!
"Allllen" wrote:
VLOOKUP
Sheet1
Model Pwr
DL 360 180
DL 385 260
ML 375 300
MSA 30 400
Sheet2 Formula in cell L2
=VLOOKUP(K1,Sheet1!A:B,2,0)
if your sheet is not called Sheet1, replace as appropriate.
if you have spaces in it, you may need something like 'My Worksheet'!A:B
if you are doing in in the same sheet, it is just
=VLOOKUP(K1,A:B,2,0)
--
Allllen
"slimbim" wrote:
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.
|