Okay, well I figured out how to take care of the earlier question I had about
the Vlookup formula, and you're right ... so that's all taken care of.
I have another problem that I could use some help on however.
The file I'm using the Vlookup formula in is about 8.4 MB in size. When I try
to do sort functions, and sort several thousands of rows of data, I get a
message back saying the clipboard cannot be opened. If I sort a smaller portion
of the data -- say 3000 rows or so -- and go to save it, I get a message that
comes back saying Data Not Saved.
Can someone tell me what the problem is I'm having here?
I have 224 MB of RAM and a 40 GB hard drive of which only 6 GB or so is being
used. I'm running Windows XP Home Edition and am using an older version of
Excel -- from Office 97.
Also, and this is really frustrating too, but every 15 minutes or so when I'm
working on this spreadsheet I have a window that pops up saying something like
"Microsoft Excel has encountered a problem and needs to close." Needless to
say, I always lose my unsaved data.
Any suggestions?