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: 16235
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

Need VLOOKup formula which pulls data from spreadsheet located

Customer Question

Need VLOOKup formula which pulls data from spreadsheet located in my documents
Submitted: 2 years ago.
Category: Microsoft Office
Customer: replied 2 years ago.
(Posted by JustAnswer at customer's request) Hello. I would like to request the following Expert Service(s) from you: Live Phone Call. Let me know if you need more information, or send me the service offer(s) so we can proceed.
Expert:  Jason Jones replied 2 years ago.

If anyone wishes to ask Jason a question directly,
they can do so at the following page:

I am an Information Technology Professional with over 15 years of professional experience. I am the technician assigned to your case today. I look forward to working with you and resolving this problem.
You can easily do this by having both spreadsheets open when you create the VLOOKUP formula.
In the spreadsheet that you are entering the VLOOKUP formula, do the following:
- When the VLOOKUP asks for the table_array simply choose the table in the other spreadsheet.
If you need help doing this, please let me know. I can remote into your system and show you how to do this.
I will be standing by.
Thank you,

Related Microsoft Office Questions