I am doing a lookup from one tab to another. The process is extremely slow. I am calculating on 4 processors. Is that necessary? If I hit the escape key, it "sometimes" stops the calculating process and leaves the lookup results. Can I trust the results? Is the calculating 4 processors a necessary process or is there a way to do it? 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.
Liz B