ExcelBanter - OFFSET & MATCH

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - OFFSET & MATCH (https://www.excelbanter.com/excel-discussion-misc-queries/195635-offset-match.html)

Warren Easton

OFFSET & MATCH

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

Bob Phillips[_3_]

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

Warren Easton

OFFSET & MATCH

Thanks Again
--
Regards
Warren

"Bob Phillips" wrote:

=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

All times are GMT +1. The time now is 02:23 PM.