Sounds more like a query than a lookup. You can use MS Query to do
what you described.

Make sure the file you're extracting from is closed or you'll
experience a memory leak.

Cliff Edwards