I hope it is okay to repost this question; my original post seemed hard to
follow and poorly titled.

I need to do a lookup that can find all instances of a value in multiple
columns of an array, and then return all the values in the "A" column of that
array of rows found to contain that value. For example, see the following
array:

A B C D
1 Pres Sam Dot Ed
2 SVP Dot Ed Bill
3 VP Ed Sam Sue
4 Dir Sue Dot Ron

The lookup, when told to find "Sam", would return the following array of
data (the values in column A of any rows containing "Sam"):
Pres
VP

If told to find "Dot", the result would be:
SVP
Dir

So I think the formula should be entered as an array, so that one formula
would return all the needed results.

If necessary, I can move or copy column A to the right side of the array.

Thanks in advance, this one has me stumped!