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

NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

I have two spreadsheets. One with full barcodes

Customer Question

I have two spreadsheets. One with full barcodes 0110305171355018
the other with the ten digits in the center that match(###) ###-####
I need to match up the columns. I tried Vlookup, but it didn't give me the result I hoped for.
Submitted: 3 months ago.
Category: Microsoft Office
Expert:  Jason Jones replied 3 months ago.

Hello,
I am the person that will be helping you today. Please, upload the documents.

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"
Please, send your reply below in the box. After you type your message, click the Send button.

Thank you,
Jason

Customer: replied 3 months ago.
394738 I am trying to match those two columns of numbers and place them in column B on the Meditech spreadsheet
Expert:  Jason Jones replied 3 months ago.

Which "Two columns" are you referring to? Please, walk me through two examples.