table array

[excelmaze]

I was looking at someone's HLOOKUP formula and could not understand how the table array works. Shouldn't any cell reference have both letters and numbers? The formula I was looking at have only numbers.

The formula looks like this:

= HLOOKUP(A$1, 'depreciation'!2:103,'depreciation'!Y102,FALSE)

What does 2:103 mean? Thanks!

 

[T. Valko]

I was looking at someone's HLOOKUP formula and could not understand how the table array works. Shouldn't any cell reference have both letters and numbers? The formula I was looking at have only numbers.

The formula looks like this:

= HLOOKUP(A$1, 'depreciation'!2:103,'depreciation'!Y102,FALSE)

What does 2:103 mean? Thanks!

2:103 means the entire rows 2 to 103.

If they were using Excel 2003 then the same range could be written as:

A2:IV103

In Excel 2007 and later it would be:

A2:XFD103

 

[excelmaze]

Thanks! I should have guessed

 

[T. Valko]

Thanks! I should have guessed

You're welcome!