Dynamic column vlookup

[saechaoc]

How do you pass a variable into a vlookup function? I have no idea how many columns are I need to comb through so I need the column range to be dynamic

Please Login or Register  to view this content.

I wanna pass this into a vlookup for the column range so that its always the last column in the region

[lookingforhelp1]

Does it specifically need to be VBA?

If you wanted to do this via formula a way would be to create a table (lets just say you called it Table1)

Put this formula into a random cell (lets just say Z10) - =COLUMNS(Table1)

This should return the total number of columns,

Then, set up a cell to type your search criteria (lets just say Z11).

Now if you always want to use the final column, your vlookup would be: = Vlookup(Z11,Table1,Z10,False).

[saechaoc]

Can you use the columns formula for a pivottable?

[saechaoc]

Oh wait you just gave me a great idea THANK YOU!!!!

[lookingforhelp1]

You're welcome!