OFFSET & Match

  • Thread starter Thread starter Warren Easton
  • Start date Start date
W

Warren Easton

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)
 
I don't know......but it's not a FrontPage problem.

You might want to post this question to the correct group: the group you
posted to is for FrontPage (Web Designer).

Have you tried the Excel newsgroups?
 
Back
Top