Lookup Function and Changing Data Sets

  • Thread starter Thread starter Nasdax
  • Start date Start date
N

Nasdax

I have a single database that is queried using the LOOKUP funtion. Thi
function is propogated on about 30 worksheets throughout the workbook.
Unfortunately the database is not static and will gain incremental dat
overtime.

Is there an easy way to change the array in my LOOKUP function (t
accomodate the additional data) and have it automatically updated i
all the funtions throughout the workbook?

Thank
 
create a defined name for the lookup table such as
insert>name>define>name it whatever>in the refers to
=offset($a$2,0,0,counta($a:$a),12)
and use the name in your lookup
=vlookup(a1,whatever,3,0)
 
Apply a name the the lookup range. If your range goes from A1 to E5
apply the name to the range A1 to F6. That makes things a lot easie
when adding rows or columns. Right clicking column F or row 6 an
selecting insert, will widen the range automatically.

-Gitcyphe
 
If you use this method it is not necessary (but it is desirable) to name the
range.
 
Back
Top