If function question

What you need is a table and a simple VLOOKUP formula that refers to it. Something like the yellow cells in the attached file.

Sounds like you want something like this...

Data Range

	B	E	F	G
1	------	------	------	------
2	Data1	x		Data1
3	Data2	x		Data2
4	Data3	a		Data8
5	Data4	s
6	Data5	g
7	Data6	d
8	Data7	h
9	Data8	x
10	Data9	c

This array formula** entered in G2:

=IFERROR(INDEX(B:B,SMALL(IF(E$2:E$10="X",ROW(E$2:E$10)),ROWS(G$2:G2))),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down until you get blanks.

Two different interpretation... If neither are correct; please attach a sample workbook.


Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

However, nothing on this Forum works quite as well as you might expect. The attachment icon doesn't work!! (Helpful, isn't it!!). Instead, just before you submit your post, click on GO ADVANCED (near the bottom) and then scroll down to Manage Attachments to open the upload window. The relevant instructions are at the top of that screen.

You're welcome. Thanks for the feedback!