Ken's suggestion works fine for me.
Did you try copying it direct from his post,
then paste into the formula bar, and copy down?

As for:
.. it doesn't update automatically with new data.
Both INDEX and INDIRECT options should auto-update
Check that the calc mode is set to automatic
(Click Tools Options Calculation tab Automatic OK)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"BarbnSLC" wrote:
Ken: Thanks. However, I keep getting #REF! with the formula you provided
and it doesn't ask for the data linked file. If you have any helpful info, I
would appreciate it. The formula using the INDEX command seems to work
(posted in a previous reply), but it doesn't update automatically with new
data.

What is the difference between the INDEX and the INDIRECT command? Will the
INDIRECT command update automatically?

Thanks
BarbnSLC