Hi David,
you can use a filter for this
Select column A, Data, Filter, Auto Filter

choose 002 (or will it be 2) from the list

You can paste from the sheet that is filtered and it will not
include cells that have been hidden due to filtering.

More information on Filtering
http://www.contextures.com/tiptech.html

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"David" wrote in message ...
I have a column of numbers such as

A B C
1 002 015 102
2 034 002 008
3 015 048 120
4 076 005 008
5 002 048 076

What I would like to do is choose a number such as 002 and get a listing of
all numbers that are in the same column..

So if I put 002. I would get a return of 015, 102, 034, 008, 048, 076.
If I did 015 I would get a return of 002, 102, 048, 120.

I do not care if it comes back with duplicate entries or sorted. Any
assistance would be appreciated.