VLOOKUP Range update

[Corleone]

I have a spreadsheet which uses a VLOOKUP to extract info from
data imported into another tab within the same spreadsheet.

The problem is is that the data imported each wek will have a different
amount of rows, therfore the VLOOKUP formula will not be correct.
For example this week the VLOOKUP is correct as it refering to a range of data containing 2519 rows

$A$2:$C$2519,2

However - next week there will be a different amount of rows in the range

Is there a way of making the VLOOKUP formula automatically re-align
so that it matches the range.
whether it be via a macro or any other means

Thanks

 

[SteveO59L]

Why not use

A:C

as the range ?

 

[Bill H]

Or you might try a dynamic named range for the vlookup.


In the ‘Refers To’ box type: =OFFSET(A2,0,0,COUNTA(A:A),3).