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. |
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) |