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 Jones Your Own Question
Jason Jones
Jason Jones, Computer Technician
Category: Microsoft Office
Satisfied Customers: 16427
Experience:  Over 10 years work experience.
Type Your Microsoft Office Question Here...
Jason Jones is online now
A new question is answered every 9 seconds

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

This answer was rated:

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...

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

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 3 years 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's my email [email protected]

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 3 years ago.



I had the tables justified nice and neat, but, they show up all crunched up 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 3 years ago. 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 3 years ago.

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

You can upload the spreadsheet.

Please, be forewarned that the site is not secure:
- Click the following link:
- 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 3 years ago.


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....

Thank you.
Customer: replied 3 years ago.

File: 585984

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:

Customer: replied 3 years ago.

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

Can you do a re-send? Thanks, Ron

I double-checked and it is working.

I am not sure which link you are clicking.

Here it is again:
Customer: replied 3 years 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...

I don't know what you are doing.

Please, try this link:
Customer: replied 3 years 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 3 years ago.

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


Thank you.

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

- Jason
Customer: replied 3 years 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?



What is the data range of sheet 2 and what is the sheet #2's name?
Customer: replied 3 years 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

Thank you

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


And you would put the following formula into Sheet1-D2


Jason Jones and 6 other Microsoft Office Specialists are ready to help you
Customer: replied 3 years 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

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:

Thank you again,
- Jason

Customer: replied 3 years ago.

Okay...Sounds good!