I'm working on automating an Excel report that uses VLookups to get some of the data, but there's approximately 3000 lines in the report, which makes the macro run for close to 20 minutes at its worst. So I'd like to try to find some alternative to VLookups which will allow me to copy over data if the information I'm looking for is in the second file, but input a zero if the information is not found.