Index Results Help

		Microsoft Office Forums > Microsoft Excel > Excel
Index Results Help

01-04-2019, 11:58 AM

radicalrom radicalrom is offline

Windows 10 Index Results Help

Office 2016

Novice

Join Date: Jan 2019

Posts: 9

Quote:

Originally Posted by xor

Shortened array formula in K2:

=IFERROR(INDEX($A$1:$H$16,SMALL(IF($A$1:$A$16=$J$1 ,ROW($A$1:$A$16)),ROW(1:1)),3),"")

This is AWESOME! Thank you, Thank you and Thank you!!!!! I love the shorter version!

Tags

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:36 AM.