Index match help

[Russk68]

Hi All,

I want to search column B1:B100 and return names in column A but only where there is text in column B.
Example:
There a 2 places in column B that text is found:
A1=Bob B1=""
A2=John B2=""
A3=Amy B3=Job 1
A4=Dave B4=""
A5=Sue B5 Job=3

The formula will go in B101 and drag down and across with column A anchored.
B101 Amy
B102 Sue

Thank you!

 

[AhoyNC]

Try:

Excel Workbook
	A	B
1	Bob
2	John
3	Amy	Job
4	Dave
5	Sue	Job
101		Amy
102		Sue
Sheet

 

[Russk68]

Hi Ahoy

This works for 1 column but when I drag the formulas across, columns C and on. show the same results of whats in column A.

I tried to tweak it but I can't get it to work how I need it to.

Would you be able to help me further?

I appreciate your time on this.

Thank you!

 

[AhoyNC]

Not sure of your layout, so I'm guessing, but something like this?

Excel Workbook
	A	B	C	D
1	Bob		job
2	John		job
3	Amy	Job		job
4	Dave		job
5	Sue	Job
101		Amy	Bob	Amy
102		Sue	John
103			Dave
Sheet

 

[Russk68]

Ahoy mate!
Works perfect!
Thank you very much for your time!

Russ

 

[AhoyNC]

You're welcome. Thanks for the feed back.