How To Write a Vlookup where the data array changes each time the v lookup is used

[AnnaL96]

Hi All
I'm trying to do a Vlookup on a file that gets automatically downloaded to the computer from a website. The data is in lots of different data sets, like so:
Loans to countries
Mar
Apr
May
Jun

Loans to banks
Mar
Apr
May
Jun

Every month a new row of data gets added to each table, meaning the start and end cells of the array also shift each time. Could someone please help with how to change the array for this?
Thanks
Annie

 

[Andrew Poulsom]

What do you want to look up exactly? You can use INDEX/MATCH to return a reference to the starting cell of the lookup table.

 

[T. Valko]

Hi All
I'm trying to do a Vlookup on a file that gets automatically downloaded to the computer from a website. The data is in lots of different data sets, like so:
Loans to countries
Mar
Apr
May
Jun

Loans to banks
Mar
Apr
May
Jun

Every month a new row of data gets added to each table, meaning the start and end cells of the array also shift each time. Could someone please help with how to change the array for this?
Thanks
Annie

Just refer to the entire column.

Instead of doing this:

=VLOOKUP(A1,X1:Y10,2,0)

Do it like this:

=VLOOKUP(A1,X:Y,2,0)

 

[AnnaL96]

Thank you very much, I'm very grateful that you took the time to answer, but I'm going to try writing a macro to perform the same function.

 

[T. Valko]

Thank you very much, I'm very grateful that you took the time to answer, but I'm going to try writing a macro to perform the same function.

Good deal. Thanks for the feedback!