Vlookup changing array

Hi All,

I have come across an interesting problem concerning the vlookup function. What i am trying to do is to make the lookup array change based on criteria. So the row of the array may never be the same. for example one month the formula may be:

=VLOOKUP(A2,$M$2:$P$25,2,FALSE)

but when the user updates the form the next month the formula needs to be:

=VLOOKUP(A2,$M$2:$P$46,2,FALSE)

I can recognize the row number that i need to go to, in the examples 25 or 46, but i do not know how to put a changing value in the lookup array of the function.

Any help is greatly appretiated. Thanks!

I have it stored in say A3, it is just a countif statement because in L1:L2000, i have numbers that repeat so like 20-1's, 20-2'2, so i am counting the number of 1's to give me the number that my array needs to go down to. Hope this helps. Thanks!

zbor, that worked perfectly!

Thanks so much!