vlookup with changing table_array parameter

[saadkhan]

Hi Experts,

I've been trying to give the VLOOKUP function a changing parameter for table_array.

I have one column (M1) for starting index (x), one for ending index in N1. Using these two columns, I determine the target array the vlookup function will use (I already know the column range). In the third column, O1, is supposed to have the vlookup funciton such that the table_array parameter will be Ax:Dy. But I cant make it work. I have even tried doing:

=VLOOKUP( 1 , "A" & M1 & ":D" & N1 , 4 , false )

Any suggestions how I can put an changing array in the VLOOKUP function?

Thanks in advance!

 

[VoG]

Try

=VLOOKUP( 1, INDIRECT("A" & M1 & ":D" & N1), 4, FALSE )

 

[saadkhan]

Try

=VLOOKUP( 1, INDIRECT("A" & M1 & ":D" & N1), 4, FALSE )

Jeez, Thanks a lot !! Cheers!