Thread: How do I find the cell reference for a vlookup?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs daddylonglegs is offline
external usenet poster
  
Posts: 1
Default How do I find the cell reference for a vlookup?

If your lookup range is A1:A10 and you want to return the corresponding
value (but one below) from B1:b10

=INDEX(B1:B10,MATCH(XYZ,A1:A10,0)+1)


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

Reply With QuoteReply With Quote