I've just got myself into another fix and need some help rectifying the problem. Any help would be really appreciated!
So I have a main data sheet (K2 kiln data) which references a lookup table (table5- however this is strange in itself, something I'll come on to) for some of its' data.
I have a second worksheet (tally data) which uses the same data in table5 for its own lookup, however this data I have duplicated in another table (TCLook) within the worksheet.
The problem I seem to have is that the Vlookup in K2 kiln data is referring to the lookup table in the Tally data sheet instead of table5.
As a result the new data entries in the main datasheet are not being updated.
When I went to Name Manager I noted that there were two entries for the vlookup table in K2 data, one in the K2 data sheet, and one in the tally data sheet. I've also noticed that when the K2 data table is selected, the table name is stated as Table5 rather than the name stated in the formulas. It doesn't matter how many times I change the name of the table, it always comes up as table5.
What I have tried so far:
renaming the table in K2 data to table5 and amending the formulas accordingly- no improvement
deleting the table from the tally data- this deleted all of my data from the K2 data sheet
making a new look up table in the tally data, giving it a new name, and changing the formulas in tally data accordingly, hoping this would make excel differentiate between the two- no improvement in K2 data sheet
it seems that when I created the lookup in the tally data, rather than create a duplicate of the lookup in K2 data, I created a linked table or something- I say or something because only the names are linked, the data is not.
So what I want to achieve is to un-link the k2 data look up formulas from the tally counter lookup table.
I appreciate this is complicated but I really need some help here!
Thanks
Jon
So I have a main data sheet (K2 kiln data) which references a lookup table (table5- however this is strange in itself, something I'll come on to) for some of its' data.
I have a second worksheet (tally data) which uses the same data in table5 for its own lookup, however this data I have duplicated in another table (TCLook) within the worksheet.
The problem I seem to have is that the Vlookup in K2 kiln data is referring to the lookup table in the Tally data sheet instead of table5.
As a result the new data entries in the main datasheet are not being updated.
When I went to Name Manager I noted that there were two entries for the vlookup table in K2 data, one in the K2 data sheet, and one in the tally data sheet. I've also noticed that when the K2 data table is selected, the table name is stated as Table5 rather than the name stated in the formulas. It doesn't matter how many times I change the name of the table, it always comes up as table5.
What I have tried so far:
renaming the table in K2 data to table5 and amending the formulas accordingly- no improvement
deleting the table from the tally data- this deleted all of my data from the K2 data sheet
making a new look up table in the tally data, giving it a new name, and changing the formulas in tally data accordingly, hoping this would make excel differentiate between the two- no improvement in K2 data sheet
it seems that when I created the lookup in the tally data, rather than create a duplicate of the lookup in K2 data, I created a linked table or something- I say or something because only the names are linked, the data is not.
So what I want to achieve is to un-link the k2 data look up formulas from the tally counter lookup table.
I appreciate this is complicated but I really need some help here!
Thanks
Jon