Thread: Offset VLookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Offset VLookup
I think I figured it out.

"=OFFSET(INDEX(A:E,MATCH(H1,A:A,0),5),3,,,)"

Reply With QuoteReply With Quote