INDEX

C

CJ

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
 
C

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDES and #Value! 1
Streamlining a long IF=(AND formula ?? 2
Circular reference confusion 1
Count Values in a Range, Not Formulas 2
How can I test for nulls within a range without specifying each ce 2
Rounding up totals. 6
Making a Formula Contingent on Check Boxes 5
Smaller VBA? Loop or Offset? 3

Top