• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pull Data

C

CMelton313

New Member
Hello. I have a work book that I'm trying to pull data from 2 spreadsheets. First, I need to match my Container ID's on both spreadsheets. The first spreadsheet has a listing of Asset ID's I need to move to the second spreadsheet by matching the Container ID's. The first spreadsheet has the Container ID's associated with the Asset ID. For the second spreadsheet, I'm trying add the Asset ID with the Container ID. The first spreadsheet has the Container ID listed once. The second spreadsheet can have the Container IDs listed multiple times and those need to be associated with the Asset ID's. I've tried everything I can't find a solution.
 
CMelton313
Please, reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
especially part
How to get the Best Results at Chandoo.org
There are useful hints, which You skipped.
 
This is may be an relatively easy task employing Power Query. Post a sample file for us to work with. Make sure you show a before and after scenario. Mock up the After. The files need not be large. Sample file may have 10 or so records which are representative of your actual file.
 
You must log in or register to reply here.
Back
Top