Hi Norman,
I wish I knew! That is why I am trying to overcome the problem. In UserForm1
I used even (Trim(TextBox2.Text)) to make sure there are no blanks in
between. But somehow, I keep getting the "#N/A" error. Meanwhile, if I type
"TOTAL_POPULATION_FORECAST" table_array, it works perfect! Any ideas?