Lookup tables

R

reno

want to use lookup tables as poor man's db.
have about 200 uniquely numbered stores, each time a call comes in we log it
by that number, and each "record" has 11 "fields" or columns. if the list is
sorted in ascending order, how can i use a a vlookup in combo with macro to
go in and key off the unique number and bring all the rows of data back
identified with that unique number to one page?
Stores may have only one "record" and some may 15.
formula would look at the keyed in number...say 101 and go to lu table and
start with 101 and repeat until it reached 102.
any ideas?
 
R

reno

what it want to do after i can pull the data, is to print it out on form.
For example, I can put say the unique store number of 195 and one part of
the lookup table will fill in all the "permanet" data from that lookup table,
then using the same number it will put all the call incidents from another lu
table.

i would want the lookup up to run for all the lu numbers identified above as
say 195

and bye the way, you have given me about 1/2 dozen excellent solutions in
the past--thanks!!
 
Top