| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTable - Where have the units/records gone? | Excel Worksheet Functions | |||
| Otto M. - Data Matching | Excel Worksheet Functions | |||
| specify date source for x-axis (adjacent to data column in Excel) | Charts and Charting in Excel | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
