EMOM,

WHY NOT JUST ANSWER THE QUESTIONS OF THOSE WHO TRY TO HELP YOU?

"Please post your formulas. Is the data sorted? What values are you looking
for? How big are the ranges?"

--
Kind regards,

Niek Otten

"Emom" wrote in message
...
There are 35 sheets of 100 columns and 120 rows of vlookups. I have 512
MB
of ram so there should be no problem with memory

"Kevin M" wrote:

Emom, how many VLOOKUPs are we talking here? What kind of hardware?

"Emom" wrote:

I have a lot of vlookups and I have tried everything. The data is one
the
same workbook, the data is copy past value so that it isn't tying to
anything. I don't have any links on this sheet, but sometime it takes
20-40
minutes to calculate. It doesn't tie up the machine, but it shouldn't
take
that long