How can I get excel to return multiple values from one input

[pui]

Hello,

I'm working on my model but I couldnt figure out how to do it.

Basically, I want excel to give me the name of customers who I'll migrate.

From the uploaded file,

If I want excel to show the list of customer I migrated as show in A13,A14 (in this case customer A and D), giving the input B1:F1 = B12 which is 0, what formula do I need to use?

Thank you so much in advance,

 

[Somendra Misra]

Hi Pui,

Try below formula in A13 and copy down:

=INDEX($B$3:$F$3,,SMALL(IF($B$1:$F$1=$B$12,COLUMN($B$3:$F$3)-COLUMN($B$3)+1),ROWS(A$13:A13)))

Enter with Ctrl+Shift+Enter.

Regards,

 

[Hui]

Pui

Firstly, Welcome to the Chandoo.org Forums

In A13: =IF(COUNTIFS($B$1:$F$1,$B$12) < ROWS($B$1:$B1), "",INDEX($3:$3, SMALL( IF($B$1:$F$1 =$B$12, COLUMN($B$1:$F$1)),ROW(A1)))) Ctrl+Shift+Enter
Then copy down

See attached file:
Hui...

 

[pui]

Thank you both of you! that's so awesome!!
you guys saved my life

BRs,

Pui