nesting within vlookup

[spxer]

I am trying to nest an address in vlookup() for the table array without
luck. Is this not allowed?
IE: the table array is located at L:M
VLOOKUP(I6,N1:M,2) where N1=L
I get the #NAME error

 

[daddylonglegs]

You could use INDIRECT

=VLOOKUP(I6,INDIRECT(N1&":M"),2)