Solved

Excel Foruma to compare to excel sheets

Posted on 2014-02-06
2
318 Views
Last Modified: 2014-02-06
Hi

How can I compare to columns (on different spreadsheets in the same workbook) that may have the same data (string value) and then enter in another value from a column that contain data.

For Example

Sheet 1
Column a
Accounting

Sheet2
Column A     Column b
Accounting    AA-Accounting

What I need to do is compare the sheets and move column b to sheet 1 column b
The sheets may not be in the same order or one sheet may have more than the other

Is there a formula that can do this or is there a quick macro that can accomplish this

Thank you for all of your help in advance
0
Comment
Question by:thomasm1948
2 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
Comment Utility
You can use VLOOKUP

e.g.

=VLOOKUP(A2,'Sheet2'!A:B,2,0)

this returns result from second column of range Sheet2!A:B where A2 in your active sheet matches column A of Sheet2.

You can copy down.

Alternate:

=INDEX('Sheet2'!B:B,MATCH(A2,'Sheet2'!A:A,0))
0
 

Author Closing Comment

by:thomasm1948
Comment Utility
That worked perfect.  Thank you very much
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now