View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default Returning a cell reference with a formula?


Are you attempting to find the second match for F12 and return a value
in the corresponding row? This should do that

=VLOOKUP(F12,INDEX(L1:L20,MATCH(F12,L1:L20,0)+1):N 36,2,0)

Note that this will return a value from column M, is that what you
require


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