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 a file. I need the files links via vlookup and then

Customer Question

I have a file. I need the files links via vlookup and then do a reverse vlookup so I know whta's missing to then add to the source file
Submitted: 8 months ago.
Category: Microsoft Office
Expert:  Jason Jones replied 8 months ago.

Hello,

I am the person that will be helping you today. May I ask for you to upload the files along with a description of what needs to be imported & added?

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"
I will be standing by, looking forward to your response.

Thank you,
Jason

Customer: replied 8 months ago.
I tried to sending it 3 times last night.
Customer: replied 8 months ago.
I have a .csv. file that need to a V-look up added to see what is missing. Also I need to do a reverse look up so I can add to the master file what is missing and reconcile
Customer: replied 8 months ago.
The master file must be too big...
Customer: replied 8 months ago.
The file is 151 mb. Can only upload 100mb. What do I do?
Customer: replied 8 months ago.
Hello?
Expert:  Jess M. replied 8 months ago.

Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.

I am very sorry about your issues. Do you still need help with this?

Please let me know by replying to me here so that I can help you further.

Best regards,
Jess

Customer: replied 8 months ago.
I have a file. It is linked through pivot tables and creates a summary. In doing so, there is a csv that is tied to a tab named Trial balance. We create a vlookup to easily link the numbers to the trial balance file. The column in the file is titled 10/31/2015. This file comes from our accounting system. This file may have had additonas through the course of the month. So a reverse vlook up would need to happen to occur to make sure any additions are included in the source file.
Customer: replied 8 months ago.
It;s very simple bu the vlookup part is where we have issues. We also would like to know if a vlook up could automatically be in place is we dump the csv into the source fikle under a different tab
Expert:  Jess M. replied 8 months ago.

Thank you for writing back. I got your 2 files named EDC Feb 2016.xlsx and Feb2016.csv.

In which file you want to do the VLOOKUP? On which column?

Customer: replied 8 months ago.
The Vlookup needs to be in the source file named EDC Feb 2016. The Feb 2016 is the data file. The Vlookup should be for data in the FEB 2016 csv and tied back to the Trial balance tab in the EDC Feb 2016
Expert:  Jess M. replied 8 months ago.

Thank you. Please give me a moment to check the files and your requirement.

Related Microsoft Office Questions