Forum Discussion
Using Indirect to lookup a column value
I am attempting to access a structured reference in an Excel table by building the string with Vlookup and using Indirect to access the value. =VLOOKUP([@LastUpdate],Status,2) = [@Column2] =IND...
as you noted, INDIRECT has 2 optional formats and neither is a table reference format.
If possible I would avoid using INDIRECT. create the reference directly. can you share the sheet and what you are trying to do. you almost always can do it another way and then avoid that INDIRECT all together, which is a good thing because INDIRECT is a 'volatile' function that will always recalculate so in a large sheet with many INDIRECT statement it will slow excel down
If possible I would avoid using INDIRECT. create the reference directly. can you share the sheet and what you are trying to do. you almost always can do it another way and then avoid that INDIRECT all together, which is a good thing because INDIRECT is a 'volatile' function that will always recalculate so in a large sheet with many INDIRECT statement it will slow excel down