Search multiple values against list

Hi,

I'm constantly having to search for individual part numbers against a massive database of about 69000 items.

i can search each number individually but it takes a considerable amount of time.

Is there a function i can put in place that allows me to lookup a list of numbers against the master list and pull the data together?

Thanks as always

K