Multiple matches in multiple columns

[ExcelIsMyFave]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Manager
[/TD]
[TD]District Manager
[/TD]
[TD]Supervisor
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Bill Smith
[/TD]
[TD]Jill Smith
[/TD]
[TD]Bobby Jones
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Jill Jones
[/TD]
[TD]Tony Anderson
[/TD]
[TD]Billy Binson
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Sally Smithers
[/TD]
[TD]Andy Fitts
[/TD]
[TD]Norm Macky
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]Partial Text Search:
[/TD]
[TD]ji
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Manager
[/TD]
[TD]District Manager
[/TD]
[TD]Supervisor
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]Returned Matches:
[/TD]
[TD]Jill Smith
[/TD]
[TD]Bill Smith
[/TD]
[TD][/TD]
[TD]Bobby Jones
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Jill Jones
[/TD]
[TD][/TD]
[TD]Tony Anderson
[/TD]
[TD]Billy Binson
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Jill ?

[/TD]
[TD]?
[/TD]
[TD]?
[/TD]
[TD]?
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Jimmy?
[/TD]
[TD]?
[/TD]
[TD]?
[/TD]
[TD]?
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Assume I have a large spreadsheet similar to the above.

Let's say that in cell B6, the user puts in partial text, so that we can find the full name of the person in the spreadsheet. After pressing ENTER in B6, other cells will populate with the returned matches. For example, if user presses "ji", the returned matches would populate as shown above.

I'm really new to this stuff, but I'm assuming I need to use Index and Match functions.

Any ideas?
Thanks in advance

 

[ExcelIsMyFave]

Would the correct approach be to generate the row numbers and column numbers for all the matches, and then use the Index and Match function to generate the results?

For starters, I've been able to generate the row numbers (for all instances of the partial text search) with the formula:
=small(if(isnumber(search($B$6,$A$1:$C$4)), row($A$1:$C$4)), row(1:1)) CTRL + SHIFT + ENTER

And then I copy and drag this formula down, to span multiple rows.

This seems to work ok for rows, but for columns, it doesn't work. Can someone provide a formula similar to the above for the COLUMNS? (recall that the partial text will appear in multiple columns, and sometimes more than once in the same column.

I'm just trying to find a really quick way to look someone up, and quickly see what their role is, and who they report to (or who reports to them). Thanks.