=OFFSET(MATCH(My frustration continues!))

C

Confused

I have text/data in cells (A1:B10)
B1 and B10 have the same data, with different corresponding entries in
Column A.

In C1 I have the formula
=OFFSET(A1:B6,MATCH(Sheet1!B1,OFFSET(A1:B6,0,1,ROWS(A1:B6),1),0)-1,0,1,1)
which gives me the data in A1, but....

what I want is to be able to look up the 2nd occurence (B10) and get the
corresponding data in A10.
 

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

INDEX, MATCH, AND OFFSET... OH MY! 4
Finding Next Largest Number Based on Criteria 3
OFFSET LOOKUP function in VBA? 9
Clean this select case code up a bit. 2
How to do this with macro? 2
range names 4
Merge Append all sheet 1
vLookup with comma break 0

Top