Need Help to learn this:

Dynamic Range Using Index().

I can do this:
=offset(A1,0,0,CountA(A:A),CountA(1:1))

But I am trying to do it using Index Function instead of Offset.


Here are the data.

---A---------B
1--x1-------xx
2--x2-------xx
3--x3-------xx
4--x4-------xx
5--x5-------xx
6--x6-------xx
7--x7-------xx
8--x8-------xx

This can be done:
Dynamic Range Row: x1 to x8
=$A$1:INDEX($A:$A,COUNTA($A:$A))
RESTRICTED TO COLUMN A.


I have tried filling the Index Syntax: but it doesn't work.
Array-------A:A
Row_No------CountA(A:A)
Column_No---CountA(1:1)


Summary:
A Dynamic Range using Index (reads Rows & Columns).

With this, I can Incorporate this into a Vlookup(C1,[Here!!!],2,false) as an
example.

If it is not possible, just give me a holler!!!
Thanks.