VLOOKUP Range update

Corleone

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

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

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).
 

Forum statistics

Threads
1,141,023
Messages
5,703,806
Members
421,318
Latest member
cg_cartoonexcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top