• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

excel hanging

Vmp

New Member
hai everyone...
i am doing daily works on excel. using window 8.1 64 bit & office 2016.
daily i have update values in 8 Lakhs records(source) from 6 lakhs (target)
using vlookup. but it is hanging my sytem. taking too much time.
i have tighred regarding this issue. please help me any one.

vmp.
 

pecoflyer

Active Member
Perhaps replace VLOOKUP with INDEX/MATCH combination. It should be faster.
Any array formulas?
Post the sheet so we can have a look at it(btw what is a lakh?)
 

lengtmp

New Member
hai everyone...
i am doing daily works on excel. using window 8.1 64 bit & office 2016.
daily i have update values in 8 Lakhs records(source) from 6 lakhs (target)
using vlookup. but it is hanging my sytem. taking too much time.
i have tighred regarding this issue. please help me any one.

vmp.
Hi buddy, the best solution probably will be to get an extra SSD, that will solve your problem and also save money from buying a new laptop.

Regards,
Kevin J. Hodge
 
Top