#n/a in table data table output
 

I constructed a one-variable data table and get several "#N/A"s returned in
the body of the table, even though I don't get the "#N/A"s when I input the
Input Variable manually. Any ideas?

Thanks! Dave

#n/a in table data table output
 

You're not giving us much to go on here.
If you're working with vlookups, a common issue is text that you think are
numbers.
For example, if you are looking for text '1234 in a table of numbers,
vlookup will not find 1234.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown


"dave" wrote:

I constructed a one-variable data table and get several "#N/A"s returned in
the body of the table, even though I don't get the "#N/A"s when I input the
Input Variable manually. Any ideas?

Thanks! Dave

#n/a in table data table output
 

Gary, Thanks for the tip. I found out the source of my problem - the data
table refered to a formula containing VLOOKUP. What I thought were integer
values in the lookup column of the lookup table were not integers, they took
the form of X.000000001. When I made the numbers integers, the lookup table
worked, as did the data table.

Dave

"Gary Brown" wrote:

You're not giving us much to go on here.
If you're working with vlookups, a common issue is text that you think are
numbers.
For example, if you are looking for text '1234 in a table of numbers,
vlookup will not find 1234.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown


"dave" wrote:

I constructed a one-variable data table and get several "#N/A"s returned in
the body of the table, even though I don't get the "#N/A"s when I input the
Input Variable manually. Any ideas?

Thanks! Dave