The INDEX function in =INDEX($C$1, Row(), 0) is looking for an entry in an
array which has one entry (C1)
Normally one uses a range as in =INDEX($C$1:$D$20, Row(), 0)
any help?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"astrodon" .(donotspam) wrote in message
...
I have give names to various lists - lets say it is
"Location" =Sheet1!$A$2:$A$108.
"View" =Sheet1!$B$2:$B$108
"PropClass" =Sheet1!$C$2:$C$108
etc.

Now lets also say I have a need to be able to reproduce that list on
another
sheet by using Data Validation | List in cell Sheet5!C1. The list being
of
course, { "Location", "View", "PropClass", ... }

Now I have placed the followng formula in cells Sheet5!C2:C108:

=INDEX($C$1, Row(), 0) Which returns a #REF error. However, typing
=INDEX(Location, ROW(), 0) gives the desired result. Why will the
INDEX(...)
function not work using a cell reference?

Is there a workaround?

TIA
astrodon
--
The writing of books there is no end