SOLVED
Home

Updating multiple VLOOKUP functions

%3CLINGO-SUB%20id%3D%22lingo-sub-423967%22%20slang%3D%22en-US%22%3EUpdating%20multiple%20VLOOKUP%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-423967%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20use%20Excel%202010%20and%20I%20have%20several%20Excel-Files%20with%20data.%20I%20use%20the%20VLOOKUP-function%20with%20changing%20dates%20as%20lookup%20value%20to%20get%20the%20data%20from%20these%20files.%20The%20cells%20have%20all%20the%20time%20the%20same%20function(cell%2C%20filepath%5Cfile%20and%20range%2C%20column%2C%20false)%2C%20only%20the%20cell%20with%20the%20date%20is%20changing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20works%20fine%2C%20except%20I%20add%20new%20content%20to%20these%20files%20and%20change%20the%20date%2C%20that%20the%20VLOOKUP%20should%20find%20the%20new%20value%20from%20the%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20select%20the%20cell%26nbsp%3Band%20enter%20the%20function%2C%20the%20wanted%20value%20appears.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20update%26nbsp%3Bevery%20cell%3F%20(maybe%20with%20macros%3F)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20yes%20the%20calculation%20option%20is%20automatic%20not%20manuel.%3C%2FP%3E%3CP%3EThanks%20for%20every%20Response.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-423967%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-429691%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20multiple%20VLOOKUP%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-429691%22%20slang%3D%22en-US%22%3EData%20tab%2C%20Edit%20links%20button%2C%20Select%20the%20file%2C%20click%20%22Change%20Source%22%20button.%3C%2FLINGO-BODY%3E
s-michael
Occasional Visitor

Hello,

 

I use Excel 2010 and I have several Excel-Files with data. I use the VLOOKUP-function with changing dates as lookup value to get the data from these files. The cells have all the time the same function(cell, filepath\file and range, column, false), only the cell with the date is changing.

 

That works fine, except I add new content to these files and change the date, that the VLOOKUP should find the new value from the file.

 

If I select the cell and enter the function, the wanted value appears.

 

Is there any way to update every cell? (maybe with macros?)

 

And yes the calculation option is automatic not manuel.

Thanks for every Response.

 

 

1 Reply
Highlighted
Solution
Data tab, Edit links button, Select the file, click "Change Source" button.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies