How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Jason Your Own Question

Jason
Jason, Computer Technician
Category: Microsoft Office
Satisfied Customers: 10583
Experience:  Over 10 years work experience.
30759776
Type Your Microsoft Office Question Here...
Jason is online now
A new question is answered every 9 seconds

Jason...Heres an example of what I want to do... I have

Resolved Question:

Jason...Here's an example of what I want to do...

I have two excel tables which each only have one column of number values that match, with each of these column headers having a different name.
Each of these two particular matching value columns also have associated values in other columns that I want brought with them as the matching numbers pair up. An example below...
here's the link to one website I've looked at in hopes of finding an answer...
http://stackoverflow.com/questions/19500352/how-to-align-matching-values-in-two-columns-in-excel-and-bring-along-associated

I can paste the matching numbers, and associated values into the same worksheet.

A simple example is this:

col a col b col c col d
API LeaseID GasID Production
12 568 564 200
13 564 568 300

I want to match up the same values in col c&d...and their associated values on either side of them.
I would appreciate you stepping in and solving this for me.

Thanks! Ron
Submitted: 10 months ago.
Category: Microsoft Office
Expert:  Jason replied 10 months ago.

Hello again and thank you for this new question.

Can you please, give me two examples of what you want as a result?

I see your sample example of values, but no end result.

Thank you.
Customer: replied 10 months ago.


Sorry! here's the end result I want...I would want all associated values with col b, and col c.


 


 


Example: LeaseID & GasID are the same numbers...just different header


 


col a col b col c col d
API LeaseID GasID Production
12 568 564 200
13 564 568 300


Desired Results:


 


col a col b col c col d
API LeaseID GasID Production
12 568 568 300
13 564 564 200

In case we lose touch online...here's my email XXXXX@XXXXXX.XXX

Expert:  Jason replied 10 months ago.
Thank you for the update.

As far as the end results go, what determines that the first line gets both 568's and the 2nd one gets 564's?

In other words, what determines that the end result is not:

12 564 564 300
13 568 568 200


Customer: replied 10 months ago.

Jason,


 


I had the tables justified nice and neat, but, they show up all crunched up again...do you see where I'm coming from with what's showing for the table example?


 


the value in the table column B, which is one of the only two of the identical numbers...I guess it really could be either one, Column b, or Col C....


 


I have two different tables of info from 2 different sources...


 


They each have their own set of columns, with the associated values...


 


I will be taking one table of data, and comparing it to another table pasted from another source with the only numbers that match in each respective column from each table, even though their header labels are not the same.


 


Each table has a set of associated values with it that I want to keep when I want to match up the numbers in the

Customer: replied 10 months ago.

Jason...to clarify a little more...


On one worksheet I have a table with only col a & col b


 


On another worksheet I have data that I want to paste from col c & col d


into the worksheet containing col a & col b and make them one big table


that's matched up by the values in col b & col c....

Customer: replied 10 months ago.


Is there any way I can send you a screen shot of the table layout to better show an example?

Expert:  Jason replied 10 months ago.
You can upload the spreadsheet.

Please, be forewarned that the site is not secure:
- Click the following link: http://www.wikisend.com
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"
Customer: replied 10 months ago.

Okay...


One spreadsheet will have the original small table on worksheet 1, and the table data that will be pasted into that worksheet, and compared in worksheet 2....

Expert:  Jason replied 10 months ago.
Thank you.
Customer: replied 10 months ago.

File: 585984

Expert:  Jason replied 10 months ago.

Thank you for that update.

You can use a simple Vlookup function.

Here is the example showing you how to do it with the document you sent me: http://wikisend.com/download/552294/VL.xlsx

Customer: replied 10 months ago.

I've downloaded the zip, but, can only open and find html files...nothing excel...


Can you do a re-send? Thanks, Ron

Expert:  Jason replied 10 months ago.
I double-checked and it is working.

I am not sure which link you are clicking.

Here it is again: http://wikisend.com/download/552294/VL.xlsx
Customer: replied 10 months ago.


I'm clicking the download button, and it shows the proper file name and all...


 


It will download to my desktop, and then extract, but, then a bunch of different "xml" files show up that look like html files...that 's all I get...I've searched through a bunch of the folders...


 


What would you suggest I do... I can give you a link to upload it to my secure Godaddy onlinefilefolder...

Expert:  Jason replied 10 months ago.

I don't know what you are doing.

Please, try this link: http://www.megafileupload.com/en/file/468335/VL-xlsx.html
Customer: replied 10 months ago.

the two previous times...I went back to the wikisend window where it showed your file to download, and all I did was hit download...the save dialog box showed up as normal, and I saved it to my desktop, and extracted the files....


 


You're link took me to the right site, but, when I tried to download the file MegaUpload keeps kicking me off when I click download file...


 


 

Customer: replied 10 months ago.


I got it...I had to turn off all of my protection to do it...

Expert:  Jason replied 10 months ago.
Lovely.

Thank you.

Please, do not forget to rate my help on the site.

- Jason
Customer: replied 10 months ago.


Jason...what do I need to add to the formula to pull the data directly from sheet #2 and populate the table?


 


What would that formula look like?


 


thanks...Ron

Expert:  Jason replied 10 months ago.
What is the data range of sheet 2 and what is the sheet #2's name?
Customer: replied 10 months ago.


I'll use the same sheets in our workbook example we used...


 


The data range in Sheet2 that was pasted into Sheet1...


 


without header labels is: A2:B3


 


With Header Labels: A1:B3


 


Worksheet Name: Sheet2

Expert:  Jason replied 10 months ago.
Thank you

In the example that I sent you, you would put the following formula into sheet1-C2

=VLOOKUP(B2,Sheet2!$A$1:$B$3,1,FALSE)

And you would put the following formula into Sheet1-D2

=VLOOKUP(B2,Sheet2!$A$1:$B$3,2,FALSE)

Jason, Computer Technician
Category: Microsoft Office
Satisfied Customers: 10583
Experience: Over 10 years work experience.
Jason and 2 other Microsoft Office Specialists are ready to help you
Customer: replied 10 months ago.

got it, Jason!


 


I sure do appreciate your help!


 


I'll be staying in touch!


 


You've got top rating from me... how will I get to the site to respond?


 


Thanks again...Ron

Expert:  Jason replied 10 months ago.
Thank you.

You can rate me above by clicking one of those faces and then clicking the Submit button :)



If you ever wish to work with me in the future, you can ask your new questions and have them sent to me directly at the following page: http://www.justanswer.com/computer/expert-computertechmaster/

Thank you again,
- Jason

Customer: replied 10 months ago.


Okay...Sounds good!

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional
 
 
 

Related Microsoft Office Questions