Stumped and Need Help

[jhcutco]

Hello all!

So here is my issue, I have an excel spreadsheet, listing data on the right and what file number that data is from.

_______________________
|01 | DATA1 |
--------------------------
|02 | DATA2 |
| DATA3
--------------------------

This is a really rough example. So what I am trying to do, is make so that if someone wants to see which sheets DATA1 is contained on, they wouldn't have to search through the whole sheet using CTRL+F.

I don't really know where to start. I was thinking of using something like,
if for example DATA 1 is found on another list, (in other words it's an entry we need to be concerned with), than...IF([Matches List],A1,""). But for DATA3 this wouldn't work, because there is no value in that position.

I also do not know how to return multiple values.

Sorry for such a long post, trying to impress the boss!

 

[Ruddles]

Apply a filter to the data column, then you can pick from a drop-down list.

Select the entire column and go Data > Filter. A little down-arrow should appear on the first row of the column. Clicky.

 

[jhcutco]

That's not quite what I need.

Maybe this will help....

http://i55.tinypic.com/vy5qwm.jpg

 

[Ruddles]

File-sharing sites are blocked by my organisation's firewall. Perhaps someone else can help.