We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Combineing two Excel files

MAVSS
MAVSS asked
on
Medium Priority
208 Views
Last Modified: 2012-05-11
Hi Experts,

I have two separate files in Excel that I want to combine. The first file has data like below:

Name         Number    data2    data3
A                1234        yes       true
B                 2345       no         true
A                6789        no         false

The second file has data like below:

Type          Number    field1   field2
X               1234          text1   text2
Y               2345         text3    text4
U               6789         text5    text4


I need to combine the second file into the first file where the link is the "Number" field. So using the sample data above:

Number           Name         data2    data3       Type        field1   field2
1234               A                yes       true          X              text1   text2
2345               B                 no         true         Y              text3    text4
6789               A                no         false         U              text5    text4

What is the best way to do this? Macros? Formulas?

Thanks!
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks gtgloner. These are two fairly large sheets so how would the formula be setup to lookup across sheets?

Commented:
I've tried that and got error messages. That's why I copied one table into the same sheet. I'll see if it's possible to do it the other way. You'll still have to re-arrange the tables so that the "Number" data is in the left-most column, that's the way VLOOKUP works.
Most Valuable Expert 2012
Top Expert 2012
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
TracyVBA Developer
CERTIFIED EXPERT

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.