Forum Discussion
How to auto update Vlookup function?
Hello, I have 2 data sheet: Sheet A and Sheet B In the sheet A i use Vlookup to extract data from Sheet B, the sheet B is updated weekly. In the sheet A the formula will be something like this: VL...
Duc1201 Well, if a Power Query generated table is the source for the pivot table, you can set the Data Source for the pivot table by the table name. Thus, rather than cell references, just use the table name.
I dont use Pivot table for my data for now but i will try that idea with the formula, Sound good. thanks
Duc1201 Ooops!!! Misread. The PQ table is a structured table. In stead of absolute references use structured table references.
The formula could then look something like this:
=VLOOKUP(A3,Table1_1,3,0)