I am also doing a lookup based from one tab to another on a very large scale. The process is extremely slow. I am calculating on 4 processors. What is the best way to be set up for this type of formula vlookup (6 column lookup into a 160K row 60 column spreadsheet)?
Thank you.