It kind of sounds like Data|filter|Advanced filter would do what you want:

http://contextures.com/xladvfilter02.html
(From Debra Dalgleish's site)

JahFe wrote:

I have very large spreadsheets with 10s of thousands of items, all with
unique identifiers. I then get a small subset of those identifiers and have
to pull full info from the huge sheet for each identifier. Performing a
"find" for every item is far too time consuming.

Does anyone know how I can take a small subset of identifiers and find them
all at once on the larger sheet?

Thanks for any help you can provide!!

--

Dave Peterson