Display an array of references

A

andy62

On one worksheet I have an array of names, starting in column B. What I need
to do on another worksheet, for any rows in the array that contain a
particular name, is display the contents of all the column A cells from those
same rows. Here's an example:

My 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

Other worksheet, selecting "Sam" from a dropdown gives following results:
Pres
VP

So my other worksheet would show just the contents from array column A where
"Sam" appears anywhere in the array. I was trying to get an array back from
the INDEX function, but it was over my head. Can this be done?

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top