Search:

Haven't done much of this lately (ended up paying someone to write a scraper!), but if I'm reading you correctly that sounds like a job for a vlookup.

Good thread this - wish it was available a few years ago, would have saved me an enormous amount of time :-)