#1   Report Post  
Posted to microsoft.public.excel.misc
CJ CJ is offline
external usenet poster
 
Posts: 102
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
CJ CJ is offline
external usenet poster
 
Posts: 102
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"