How To Move a VLOOKUP Table & maintain reference links?

How To Move a VLOOKUP Table & maintain reference links?

I am using a multi-column table that I wish to move (because it doesn't need to be seen).

The end goal is to have a worksheet that is purely a user interface
... where a few variables can be changed, and the results displayed.
... where the tables and helper cells are moved to another worksheet

For development, all the data, variables, and results, are on one worksheet, and easily visible together.
It is all functioning correctly.

Next phase is to move 'the table and various helper cells' somewhere to the right of the worksheet, so that I can develop the interface.
However, when I move the table, the VLOOKUP formulae lose linkage.

Perhaps I need to name the tables, but on all the web 'VLOOKUP aid' pages, no mention is made of this.

Can anyone advise me on the correct procedure, to allow me to move the table whenever, and wherever I want?

Thanks Glen

=VLOOKUP(M6,B28:G95,3,0)
=VLOOKUP(N6,B28:G95,3,0)
=VLOOKUP(M6,B28:G95,2,0)

I highlight the table and drag it off to the right, and I get a mass of blue arrows pointing to various cells
... I'm presuming these are warnings because I have not clicked Trace precedent or dependent.

I click back and everything is fine.

Thanks for that Glen.
Your response helps.
I now know that it should work fine.

I will study the table and reference cells.

Surely I will find something, and then report back

Well it is solved, but the root cause isn't clear.

I saved the file as a test file.
The table was moved incrementally (column by column) without issue, until I hit the X column ... when the screen lit up with tracers.
Clicked back, then ran a delete data down column X.
Repeated the move ... tracers again.
Clicked back, then deleted column X (Y became X) ... repeated the move ... tracers again.
Clicked back, then moved the table fully past the X column (the left of the table was now in the Y column) ... no issues.
I then deleted column X, causing the left of the table to be in column X ... no issues ... and thereafter no issues anywhere.

Analysis
The first time that I deleted column X ... there may have also been an issue in column Y.
By deleting column X the (postulated) issue in column Y simply transferred to column X ... I think that this must be the case.

By logic: There must have been an issue in both X & Y columns.
Ultimately, by deleting both columns, the issue was finally removed.

Concerning The Postulated Issue
When it was clear that there was a problem with Column X; I examined each cell.

The only elements of difference noted in column X (and presumably Y), was the cell formatting: Different fonts, and different number types.

I can't imagine the fonts being a problem, but perhaps the number types.
However, I would have thought that the number types would have been overwritten during the drag procedure.

Conclusion
The issue has been resolved.
Nice!

Thanks again Glen for quickly stepping into the breach.
Your action was formative, to rapidly gaining resolution (uprep).

Mention of blue arrows sounds like circular reference warnings to me...

Also feel I should mention it's almost always the best option to use absolute references in VLOOKUP, e.g.

VLOOKUP(M6,B28:G95,3,0)

becomes

VLOOKUP(M6,$B$28:$G$95,3,0)

If you didn't know then F4 toggles this when the relevant bit is highlighted (or just after you've typed it).

These two things could be related.

Thanks Nick

I had tried the absolute references, to no avail.

To be honest; I'm putting this down to a game of life event (because it's as if it never happened).
You know ... when your guardian angel decides 'it's all going too well for my boy', and she reaches out for her pixie hat

Hahahah!