I have a simple vlookup which looks up values on over 20,000 cells and matches values in a different worksheet.
I am recording the process via a macro and whenever i try to use it it takes minutes and minutes to perform the vlookup part.
Is there a quicker way??
Also it looks up values for...