Excelpromax123
Board Regular
- Joined
- Sep 2, 2021
- Messages
- 167
- Office Version
- 2010
- Platform
- Windows
Hi guys. I have an excel file with about 60,000 lines, Currently using Vlookup as the file is extremely slow. Thanks to the forum for help with the dictionary code. Search like the image described below. sincerely thank
If using a formula, then at cell G5=IF(F5="","",IFERROR(VLOOKUP(F5,$B$5:$C$60000,2,0),0)) ( 60,000 lines very slow )
If using a formula, then at cell G5=IF(F5="","",IFERROR(VLOOKUP(F5,$B$5:$C$60000,2,0),0)) ( 60,000 lines very slow )
VBA VLOOKUP Dictionary .xlsb
drive.google.com