VLookup

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

I'm currently editing an excel file for my boss where I'm inserting a bunch
of VLookup functions in order for data to be automatically entered. However,
the file from which I'm getting the data is most likely in a different spot
on my computer than it is on my boss'.

Will there be a way that I can change ALL of the VLookups at once to have
the new file name once I transfer the file back to my boss?
 
Try Edit, Links, Change Source.

--
Jim
| I'm currently editing an excel file for my boss where I'm inserting a
bunch
| of VLookup functions in order for data to be automatically entered.
However,
| the file from which I'm getting the data is most likely in a different
spot
| on my computer than it is on my boss'.
|
| Will there be a way that I can change ALL of the VLookups at once to have
| the new file name once I transfer the file back to my boss?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL - IF(IFERROR(VLOOKUP question 0
User-friendly lookup solutions needed 3
vlookup challenge with hyphen data placement 2
Excel Vlookup Help 0
vlookup using different workbooks 4
Kiosk Mode Navigation 0
Vlookup Erros 2
Vlookup Error Message - Excel 2003 8

Back
Top