Thread: PLEASE HELP OFFSET / HLOOKUP / MATCH I HAVE READ OTHER POSTS
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default PLEASE HELP OFFSET / HLOOKUP / MATCH I HAVE READ OTHER POSTS
=OFFSET(HLOOKUP($A$1,$A$3:$C$7,5,FALSE),0,-1)

Try in D2: =OFFSET(A3,2,MATCH(A1,A3:C3,0)-2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply With QuoteReply With Quote