I have a pivot table, and then a column of vlookup formulas referring to it, to the right.
rather than have vlookups in every cell in that column (i want to keep my file size down) - i would like the formulas to extend to the end of the pivot table, and match it if changed when refreshed.
Any ideas?
Thanks
rather than have vlookups in every cell in that column (i want to keep my file size down) - i would like the formulas to extend to the end of the pivot table, and match it if changed when refreshed.
Any ideas?
Thanks