Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 60
  • 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
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.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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