I rarely use rangenames unless I need to like in DV list source.

Yeah, I use them in those cases also. I should rephrase my statement:

The only time I use names is if I have to or to shorten a really long
complex formula.

Biff

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Makes sense to me Biff.

I rarely use rangenames unless I need to like in DV list source.


Gord

On Tue, 22 May 2007 22:35:28 -0400, "T. Valko"
wrote:

Some people like to name their ranges, I normally don't

Here's why:

=VLOOKUP(Sales,Table,2,0)

Looking at that formula I don't know where either Sales or Table is
located.
Of course I can find them if I look for 'em.

=VLOOKUP(A1,Sheet2!A1:B100,2,0)

Looking at that formula I know where everything is without having to look
for it!

The only time I use names is to shorten a really long complex formula.

But, that's just my preference.

Biff

"T. Valko" wrote in message
...
You can give just about every range you need to refer to like that a
name.
Some people like to name their ranges, I normally don't, but that's just
my preference.

If you have a range of data that expands you can also name that range.
It's called a dynamic range. There are instructions he

http://contextures.com/xlNames01.html#Dynamic

Biff

"The Great Attractor"
<SuperM@ssiveBlackHoleAtTheCenterOfTheMilkyWayGala xy.org wrote in
message
...
Instead of pointing to a specific sheet and data range for the second
VLOOKUP particular, I found that if one merely highlights the data
range
in the "lookup sheet", then enters a name for that data range in the
upper left corner of the sheet while it is highlighted, then all that
"sheetname!A:B" etc. stuff can be replaced simply by the new tagname
you
gave to that data range highlighted selection as in the example:

Lookup cell is: A1 (replace with your cell)
Tagged range name is: looktable (replace with your tag name)
grabbed data column is: 3 (replace with your data column number)

so:

VLOOKUP (A1,looktable,3,FALSE)

no more bangs or cell range calls!

This would be for fixed range selections given a tag name. If your
lookup table continually expands, you'll have to expand the range given
to the tag name, or tag it each time before applying the lookup. (I
think)