nesting within vlookup
 

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


--
spxer
------------------------------------------------------------------------
spxer's Profile: http://www.excelforum.com/member.php...o&userid=37025
View this thread: http://www.excelforum.com/showthread...hreadid=568151

nesting within vlookup
 

You could use INDIRECT

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=568151