When you say "calculate" the references, I'm guessing you mean that you have
a named range for those references.

Try using something like this:

=VLOOKUP(C1,'[Yourworkbook.xls]'!YourNamedRange,2)

"Gary Wallis" wrote:

I use the Vlookup function in Excel to extract information from different
parts of a csv file imported from another program. The problem that I have is
that I need to change the cell range in the Vlookup function each time I
import an updated file as the data will have moved depending on the size of
the file. I am able to automatically calculate what the cell references
should be, but cannot find a way to get these calculated references into the
function without keying them in directly, which is not practical.

I would be grateful for any help with this.