Thread: Offset VLookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default Offset VLookup
Or simply...

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

Hope this helps!

In article .com,
wrote:

I think I figured it out.

"=OFFSET(INDEX(A:E,MATCH(H1,A:A,0),5),3,,,)"
Reply With QuoteReply With Quote