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...
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)