VLookup Issue

[Guest]

I work with spreadsheets a lot for my expediting position. Tracking lead
times. I am creating a status spreadsheet that has to pull information from
several other spreadsheets as one report does not provide all information.
Right now, I simply cut and paste new information in "working" spreadsheets
and the formula is set to pull specific information (dates, quatities, etc.)
from these working sheets. The problem is when I cut and paste new
information, the Vlookup formulas always lose the table array information.
It keeps the "working" spreadsheet name, but, not the total information to
look in. Is there a constant that I can use in the formula, i.e. $ to keep
this from happening...?

 

[Barb Reinhardt]

Let's say you have the following equation:

=vlookup(B1,H1:I19,2,false)

If you want it to keep looking in the same location, whether you copy the
cells down or across, change it to:

=vlookup(B1,$H$1:$I$19,2,false)