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 Richard Your Own Question

Richard
Richard, Consultant
Category: Programming
Satisfied Customers: 31120
Experience:  Programming and Network consultancy for 15+ years
32989067
Type Your Programming Question Here...
Richard is online now
A new question is answered every 9 seconds

I have 2 sepatate tables in separate worksheets. I would

Customer Question

I have 2 sepatate tables in separate worksheets. I would like to compare the values in each table by corresponding reference numbers.
Submitted: 5 months ago.
Category: Programming
Expert:  Richard replied 5 months ago.

Hi there Rocco and welcome

Can you attach both sheets please to this question and I can see the best way to achieve this for you?

Thank you

Expert:  Richard replied 5 months ago.

If not, have you looked at using a vlookup?

This appears to be the formula you need

This link explains it

Let me know please.

Customer: replied 5 months ago.
Hi, I'm trying to compare the values between the 2 worksheets referring to the docket number references. Looking for the 'the same' & 'differences'. One worksheet is mine 'May 2016' the other 'May 16' is from my transport company, as I'm trying to check off his charges against mine.
Thanks
Expert:  Richard replied 5 months ago.

Thanks

What I did was show your Total and then next to it the total from the other sheet matched on Docket Number.

You can download it here

http://www.filedropper.com/may2016_4

Is this what you require Rocco?

Customer: replied 5 months ago.
Hi, I went to download the file and file dropper is now asking me to join for a fee to download the file. Can you send me another link whereby I don't have to pay to view your work?
Thank you
Expert:  Richard replied 5 months ago.

Sorry Rocco, thats something they have done in the last day or two, was always free until now.

You can use this link

http://wikisend.com/download/934984/MAY+2016.xls

Related Programming Questions