Hi All
I want to use xlookup instead of vlookup and the lookup array controlled by reference to a cell. for example in vlookup you can=VLOOKUP(J3,T:U,Q1,0) but in Xlookup =XLOOKUP($J2,$T:$T,U:U,0).
The reason is in the reports I am creating look at multiple pivot tables which have data by month. Using one cell you can update all formulas in one go.
Thanks guys
I want to use xlookup instead of vlookup and the lookup array controlled by reference to a cell. for example in vlookup you can=VLOOKUP(J3,T:U,Q1,0) but in Xlookup =XLOOKUP($J2,$T:$T,U:U,0).
The reason is in the reports I am creating look at multiple pivot tables which have data by month. Using one cell you can update all formulas in one go.
Thanks guys