Hi.
I'm not sure why it causes the error.

The formula is:
=VLOOKUP(A1, INDIRECT($C$15), 2, 1)
=VLOOKUP(A2, INDIRECT($C$15), 2, 1)
=VLOOKUP(A3, INDIRECT($C$15), 2, 1)

Cells A1 to A3 contain the values to lookup.
Cell C15 contains
=ADDRESS(ROW(C5),COLUMN(C5), 4) &":"& ADDRESS(ROW(C14),COLUMN(C14), 4)
=C5:C14 [answer display]

It won't work! :(
Error: #REF!

I need to use the INDIRECT function because I need a dynamic reference (the
table).
The table is being constantly updated.

How to solve this problem?
Or is there any alternative to do the same thing?

--
Additional information:
- I'm using Office XP
- I'm using Windows XP