I tried both of these formulas suggested and the result is labeled "volatile"
and not showing any numbers in the cells. Any other suggestions?

"John James" wrote:


The formula for, say, cell E6 is
=OFFSET(E5,0,A3)


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531737