Claude,

Sorting moves cell contents, not cells, but for your problem you could
move the name to the column before the answer (ie, don't use the 'Name'
feature, put a name in a cell) and use
=Match("required-name",D:D,1)
for names in column D to return to you the row number for your
answer.
I don't think the Match likes to find numbers even if described as
text, but 'label9' etc works ok.

Assuming that the answers are in culumn E and the 'Match' is in cell
F1,
=Indirect("E"&F1)
should provide the answer you need.


Earl Kiosterud Wrote:
Claude,

Sorting effectively copies cells, not moves cells, something most
apparent
when you have formulas in the table that's been sorted, but also with
range
names -- they stay put. Perhaps you can use a name column instead of
range
names.
--
Earl Kiosterud
www.smokeylake.com

"Claude38" wrote in message
...
Hello,

I have an array of cells containing questions and answers. I want
to
present those question in a different order every time. So I
generate a
list
of random numbers associated with the question-answer duets and I
use
those
numbers to change the order when I need to. But for future
processing,
each
answer cell has a name, and the name stays in its original place
after
sorting, which seems strange to me.

Is there a way around this problem ?

Thanks for helping.
Claude


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=395565