View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
spxer spxer is offline
external usenet poster
 
Posts: 1
Default 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