VLOOKUP Range update

Corleone

Well-known Member
Joined
Feb 2, 2003
Messages
714
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
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Bill H

New Member
Joined
Mar 23, 2002
Messages
21
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).
 

Watch MrExcel Video

Forum statistics

Threads
1,113,990
Messages
5,545,370
Members
410,679
Latest member
rolandbianco
Top