0
0-0 Wai Wai ^-^
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?
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?