| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating columns in worksheet based on values from another worksh.
hello all,
I apologize for simplicity of this question but I am drawing a blank on how to do this I have a workbook with two worksheets (WK1 and WK2). I would like to update column C of WK1 (with column C from WK2) if column A & column B of WK1 matches column A & column B of WK2. I have several thousands rows in each workbook but that shouldn't matter I would guess. Much thanks in advance...... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Updating columns in worksheet based on values from another worksh.
WK1
In C1: =IF(A1&B1=WK2!A1&WK2!B1,WK2!C1,"") "NBROWN" wrote: hello all, I apologize for simplicity of this question but I am drawing a blank on how to do this I have a workbook with two worksheets (WK1 and WK2). I would like to update column C of WK1 (with column C from WK2) if column A & column B of WK1 matches column A & column B of WK2. I have several thousands rows in each workbook but that shouldn't matter I would guess. Much thanks in advance...... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating worksheets from master worksheet based on column value | Excel Worksheet Functions | |||
| Help needed in updating excel worksheet values | Excel Worksheet Functions | |||
| updating formulas with named cell references in a different worksh | Excel Worksheet Functions | |||
| Regarding updating 1000 values using vlookup from another worksheet | Excel Worksheet Functions | |||
| How to create one table based on filtered data from various worksh | Excel Discussion (Misc queries) | |||
Linear Mode
