modifying columns in vlookups easily

[bigdan]

I just had to set up a vlookup formula for Jan to Dec. Was kinda annoying changing the numbers for each month, like writing vlookup(A1,B100:M200,1,false) and changing the 1 to 2 to 3 etc.


I realize we can create a helper row with 1-12 hidden somewhere and link the 1 in the formula to that instead. I dont mind doing that temporarily but I would like those numbers to get embedded in.

Is there a way to do this?

 

[bigdan]

Thanks a lot all you guys !

 

[AliGW]

You're welcome!

 

[T. Valko]

It's one perfectly valid way of doing it. There are many!

Yes, that's true but some methods are better than others!