128 reputation
117
bio website
location Santo Domingo, Dominican Republic
age 30
visits member for 4 years, 3 months
seen Feb 7 at 18:58
im just glad it's a rubber tree...

Sep
24
awarded  Autobiographer
Apr
7
awarded  Famous Question
Feb
7
revised Dynamically reference a Named Table Column via cell content in Excel
added two answer method receives and extra reading to make the question more valuable
Feb
7
comment Dynamically reference a Named Table Column via cell content in Excel
Excelent, i actually came across this method later on and have been using it since. Coincidentially i started noticing a huge slowdown on the older spreadsheets where i was using indirect on over a dozen sheets. Thanks!
Jul
1
awarded  Supporter
Apr
12
awarded  Notable Question
Feb
5
awarded  Popular Question
Aug
13
awarded  Scholar
Aug
13
accepted Dynamically reference a Named Table Column via cell content in Excel
Aug
13
comment Dynamically reference a Named Table Column via cell content in Excel
indeed that worked, i needed to reference the entire table. this worked! thanks!
Aug
13
comment Dynamically reference a Named Table Column via cell content in Excel
Yeah my table is properly named with the different columns, what i want is a method to TELL excel what column i want depending on a cell value, something like this =COUNT(Table1[A1]) Where A1 is the cell i want to contain the columnname
Aug
13
revised Dynamically reference a Named Table Column via cell content in Excel
clarification
Aug
13
awarded  Student
Aug
13
revised Dynamically reference a Named Table Column via cell content in Excel
changing title and clarifying question
Aug
13
comment Dynamically reference a Named Table Column via cell content in Excel
Currently using Excel 2007
Aug
13
awarded  Editor
Aug
13
revised Dynamically reference a Named Table Column via cell content in Excel
cleaning up a bit
Aug
13
asked Dynamically reference a Named Table Column via cell content in Excel
Nov
8
awarded  Tumbleweed