INDES and #Value!
 

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,$f$3,$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? The random number is always within the expected
range. Thanks, CJ

INDES and #Value!
 

I was able to solve my own problem: solution
INDEX($A:$A,$f$3,1)

"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,$f$3,$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? The random number is always within the expected
range. Thanks, CJ