Using Lookup on an expanding list
Hi,
I'm hoping someone can help me...
I've got a lookup on a central list of names and codes. However, this list
is ever expanding and I keep having to change the lookup references to add in
the new range. Is there an easier way to make lookup look at the whole list
without changing the range every time?
Thanks for any help anyone can give.
|