Hi,
how can we fix lookup value and range in excel table format while implementing lookup formula and xlookup,the lookup value also get drags while we drag the formula to next column.
Please revert for my query.
As i implement xlookup formula in sheet1 from master data my lookup value is customer code but when i drag it to zone column my lookup value and lookup range get change.
So i just want to know to fix lookup value and lookup range in table format for sample i have attached my working file.
Hello,
No file attached, but there is no need to upload (unless I understood your query wrong).
Do check out the blog article Excel Table Absolute Structured References • My Online Training Hub and scroll down some rows till you see the header How to Make Structured References Absolute.
Br,
Anders
