Thanks Bob - Exactly what I need.
--
Thanks,
Rob E.


"Bob Phillips" wrote:

Create a dynamic range name and use that. For instance, this defines a
dynamic range that grows as column A grows

=OFFSET($A$1,,,COUNT($A:$A),3)

The COUNT($A:$A) determines the height (number of rows), and the ,3
determines the width (number of columns).

To create a name, menu InsertNameDefine..., name it something sensible
such as NamesRange, add that formula in the RefersTo box, and use like this

=VLOOKUP("value", NamesRange,2,False)


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Rob E" wrote in message
...
Is there a quick and easy way to get a range that you have entered into a
formula or feature to expand automatically.

For example, if I am creating database functions, I want my formulae to
update automatically to include new entries I add to my data list, or a
pivot
table to update with new entries that are added to the list.

Any help would be appreciated.
--
Thanks,
Rob E.