Thread: PLEASE HELP OFFSET / HLOOKUP / MATCH I HAVE READ OTHER POSTS
View Single Post
  #4   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
Errata, it should read
In D2: =OFFSET(A3,4,MATCH(A1,A3:C3,0)-2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply With QuoteReply With Quote