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
Vincent DAsked:
Who is Participating?
 
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
 
Vincent DAuthor Commented:
THE RIGHT COLUMN IN THE TABLE THAT NEEDS TO BE UPDATED?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.