OFFSET & MATCH

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)
Click to expand...
 
B

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OFFSET & Match 1
add every other cell from another worksheet 3
VBA Coding Help for Beginner 0
SUMPRODUCT 2
Having two variable's in a macro 2
Offset, Match Questiond 7
Sheet to sheet code Type Mismatch 6
Match Copy/Paste Macro almost there 0

Top