When data match, copy adjacent value to adjacent column
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. |
When data match, copy adjacent value to adjacent column
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. |
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. |
All times are GMT +1. The time now is 04:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com