I am using INDEX for the first time with Excel 2003. Column A is a list of
names (rows 1-9 are populated, A10 & A13 are blank, A11,A12 and A14 are also
populated. I am using the functiion to extract a name at random when F9 is
pushed. the function is INDEX($A:$A,f3,$A:$A) where F3 is a random number
generator and A:A is a column of 14 names. As an experiment, I populated
cells f4 to f20 with the exact same INDEX function as shown previously.
Cells f4 to f12 and f14 give the following result: #VALUE! while at the same
time cells F13 and f15-F20 display the same name from the list. Each push of
the F9 key causes the INDEX to work as expected except for the #VALUE!. How
can the #VALUE! be stopped? Thanks, CJ

What is the value in F3 when the formula returns #VALUE!
--
Gary''s Student - gsnu201001


"CJ" wrote:

I am using INDEX for the first time with Excel 2003. Column A is a list of
names (rows 1-9 are populated, A10 & A13 are blank, A11,A12 and A14 are also
populated. I am using the functiion to extract a name at random when F9 is
pushed. the function is INDEX($A:$A,f3,$A:$A) where F3 is a random number
generator and A:A is a column of 14 names. As an experiment, I populated
cells f4 to f20 with the exact same INDEX function as shown previously.
Cells f4 to f12 and f14 give the following result: #VALUE! while at the same
time cells F13 and f15-F20 display the same name from the list. Each push of
the F9 key causes the INDEX to work as expected except for the #VALUE!. How
can the #VALUE! be stopped? Thanks, CJ

The values in F3 varies. While the value in F3 may be any value between and 1
& 14 the outcomes are simultaneously good and bad. The good is a name
selected at random which shows only in cells F13, and F15-F20. The bad is in
cells F4-F12 & F14 which is #VALUE!

"Gary''s Student" wrote:

What is the value in F3 when the formula returns #VALUE!
--
Gary''s Student - gsnu201001


"CJ" wrote:

I am using INDEX for the first time with Excel 2003. Column A is a list of
names (rows 1-9 are populated, A10 & A13 are blank, A11,A12 and A14 are also
populated. I am using the functiion to extract a name at random when F9 is
pushed. the function is INDEX($A:$A,f3,$A:$A) where F3 is a random number
generator and A:A is a column of 14 names. As an experiment, I populated
cells f4 to f20 with the exact same INDEX function as shown previously.
Cells f4 to f12 and f14 give the following result: #VALUE! while at the same
time cells F13 and f15-F20 display the same name from the list. Each push of
the F9 key causes the INDEX to work as expected except for the #VALUE!. How
can the #VALUE! be stopped? Thanks, CJ