View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Charles
 
Posts: n/a
Default 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.