|
|
|
|
#1
01-04-2019, 10:08 AM
|
|||
|
|||
It is in column 3, not 2 in your INDEX-range, so:
=IF(ISERROR(INDEX($A$1:$H$16,SMALL(IF($A$1:$A$16=$ J$1,ROW($A$1:$A$16)),ROW(1:1)),3)),"",INDEX($A$1:$ H$16,SMALL(IF($A$1:$A$16=$J$1,ROW($A$1:$A$16)),ROW (1:1)),3)) You can shorten the formula by about 50% by using IFERROR instead of IF(ISERROR(... 
|
|
| Tags |
| column, index |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can a I create an index in a word document where index entries control sections of the document? | pfriorda | Word | 3 | 12-28-2017 08:02 PM |
 Updating font in index without updating style of index
|
Nick B | Word | 4 | 11-28-2016 02:00 AM |
|
Relational results
|
tel703 | Excel | 2 | 05-19-2016 09:54 AM |
| Get Paragraph index from bookmark starting index | vince692 | Word VBA | 6 | 05-13-2016 04:51 AM |
| 2013 search results take a long time - they fill in as results in reverse date order | themookman | Outlook | 0 | 10-11-2013 12:01 PM |
Windows 10 
Office 2016
Hybrid Mode