Thread: OFFSET & MATCH
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default OFFSET & MATCH

=OFFSET(F60,MATCH('Start Sheet'!D10,F60:F70,0)-1,MATCH('Start
Sheet'!H18,F60:T60,0)-1,1,1)


--
__________________________________
HTH

Bob

"Warren Easton" wrote in message
...
Dear All,

How can I get the following formula to work if F60:F70 isn't in order?
=OFFSET(F60,MATCH('Start Sheet'!D10,F60:F70,1)-1,MATCH('Start
Sheet'!H18,F60:T60,1)-1,1,1)
--
Thanks in advance
Regards
Warren


--
Regards
Warren