I need to search a large table-  the size of the table can change-

I can't for the life of me think of the command to make a variable part of
an address
the current data range is about 400 items, the ultimate data range will hit
about 6000 items.

(I have 8760 vlookup statements processing... on one worksheet)
so rather than my Vlookup searching a1:g6000 every time,
(because that would be checking an extra 4,9056,000 cells needlesly while my
data set is small)

I've counted the # of rows in A--  and I'd like my vlookup to be looking in
a1:gVARIABLE

where variable is the current number of rows in a..

but for the life of me-  (mental momment) I can not remember how I can/what
allows me to define part of an
A1 style reference (the row in this case) from the content of another cell..