Dynamic Range with 2 columns

I'm trying to name a dynamic range for A2:B10000.... I know how to use the OFFSET function but was wondering if someone can help me do it using the INDEX function

Both column will always have the same number of used rows.


Another question:

If I have dates in Column A, and values in Column B....what formula do I need to get me the last value (last row,most recent Date)


Thanks

You only really need to use INDEX if the range contains interspersed blanks

=$A$2:INDEX($B:$B,MATCH(9.99999999999999E+307,$A:$A))