| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
=OFFSET(MATCH(My frustration continues!))
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,ROW S(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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| offset match | Excel Discussion (Misc queries) | |||
| match and offset | Excel Programming | |||
| Match Offset by more than one value | Excel Discussion (Misc queries) | |||
| Match Offset by more than one value | Excel Worksheet Functions | |||
| Match Value and then offset | Excel Worksheet Functions | |||
Threaded Mode
