How can I find multiple items on a sheet??

[JahFe]

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 to 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]

You have one response at your earlier post.

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 to 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!!
>
> --
> JahFe
> ------------------------------------------------------------------------
> JahFe's Profile: http://www.excelforum.com/member.php...o&userid=31373
> View this thread: http://www.excelforum.com/showthread...hreadid=510650

--

Dave Peterson