• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 56
  • Last Modified:

Excel 2013 updating values in one column

Hi,

Using excel 2013 and need to update one column in one table with values of one column in another table. Looking to compare for matched values as basis of importing values into column. Can use Power Query but don't want to create new workbook or table. Is it just a matter of selecting
0
Vincent D
Asked:
Vincent D
1 Solution
 
Vincent DAuthor Commented:
THE RIGHT COLUMN IN THE TABLE THAT NEEDS TO BE UPDATED?
0
 
Christopher Jay WolffWiggle My Legs, OwnerCommented:
Hi Vincent and all.

It would be helpful if you could provide more specific details.

Here are some links to accomplish similar things that might give you ideas or more specific questions.

Here's one with two column compare and highlight matches.
https://www.experts-exchange.com/questions/28959739/If-Column-A'-Words-in-one-excel-file-match-Column-A-words-in-another-excel-file-make-the-background-Yellow.html




referencing anther workbook.
https://www.experts-exchange.com/questions/28956537/Using-a-calculated-cell-to-open-another-workbook-and-sheet-and-get-data-from-a-cell.html





Pivot tables

Pivot table example.https://www.experts-exchange.com/questions/28924563/Excel-Search-Help.html


pivot tables.

https://www.experts-exchange.com/questions/28929466/Accrual-in-Access-Query.html
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now