VBA Arrays - Faster alternative than Vlookup?

I'm not sure if I can help you yet, but can you upload a small sample file with your desired results?

Sorry I'm brand new to this forum and don't know how to upload files.

I'm also unfamiliar with collections. Is there any easy way to assign a range (e.g. Data!A1:F10000) to a collection?

Thanks to all for the assistance.