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

How do I move data from one worksheet to another worksheet using only once column of data to match?

manelson05
manelson05 asked
on
Medium Priority
205 Views
Last Modified: 2012-05-11
Sheet 1 is small sample of my updated list of cities. I am needing to pull the information that correspodns with each city from Sheet 2 which is a small sample of the information I need to populate my list with. I have used some random names and information for testing purposes.

Sheet 1 I have Albuquerque with blanks for Contact and the various other headings, in Sheet 2 I have Albuquerque with all the information I need in sheet 1.

How can I pull the information over into sheet 1? The Citys which are not represented with data will be populated with another data source file once I am given that information. I need to keep the cell coloring as this will help in the next step of my data sort.

Anyhelp would be great as I have over 27,500 cities.

Thank you



RCSmaster.xlsx
Comment
Watch Question

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

Author

Commented:
If I do this then all my new data is copied with information  that is not valid. For example City Arizona is not in Sheet 2 it is a new location in Sheet 1. I would like the corresponding city on sheet 1 to pull the data that matches that city name from Sheet 2 and then pull over the contact name, and any of the other categorys that have an X in them.

Is this possible?
Hi,

It would pull the data from sheet 2 only if a city and contact matches.

Kris

Author

Commented:
I understand, but I also need the citys that are not on the source list to stay on Sheet 1, I cant overwrite them.
Hi,

You are not overwriting anything. Put the formula in C2 and copied down & across

Author

Commented:
C2 on Sheet 1 or 2?
Hi,

Sheet1

Kris

Author

Commented:
Let me try this when I get to work tomorrow.thank you

Author

Commented:
This worked well after I studied it a bit more.

Thank you!
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.