Franz,

I did what you suggest (I think). That is, I changed the format of
the indexing row (row 68, containing the indexing number) from text to
number. When I changed the format, I could then change the values in
*68 and the dereferenced values showed correctly -- no #N/A. In other
words, your suggestion works.

Thanks a lot for you help.

- Paul

On Dec 22, 7:15*pm, "Franz Verga" wrote:
Paul the problem *is* about formatting.

When you input manually a number in a cell, Excel automatically switch the
format of the cell from text to number, so this is why you have the #N/A
result.

If you format accordingly your reference row and your input cell (E68) both
with the number format *and* apply the procedure I described before to the
reference row, you should solve your problem.

But maybe I misunderstood your problem...