I can't apply a simple VLOOKUP across the data set I'm working with because it's so large (700K rows). I'm working out of a 32-bit excel and it's the only version I have access to.
I've saved the file as an .xlsb to try to save space, but that didn't help much. I have to apply the formula to a...