Hi Dan,

I would check the Lookup Table and verify that
the contained instance of:

TOTAL_POPULATION_FORECAST

has no hidden initial or trailing spaces.

Provided that the 'massaged' TextBox value is
identical to the Table value, I would not anticipate
any problem and I would expect the formula to
return the requiste values.


---
Regards.
Norman


"Dan" wrote in message
...
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?