Excel question- improving performance

ATL Aggie

Joined: May 6, 2004

Posts: 6,683

User Profile Ignore User Stop Ignoring

How long do you want to ignore this user?

24 hours One week Permanently Cancel

5:07p, 5/23/16

AG

I recently discovered that you can get a performance boost by using index match formulas in place of vlookup. Is there a resource somewhere that ranks functions by performance drain? I run models that can take a while to calculate and am currently looking for ways to boost performance.

Crown

Joined: Jun 14, 2005

Posts: 943

User Profile Ignore User Stop Ignoring

How long do you want to ignore this user?

24 hours One week Permanently Cancel

6:25p, 5/23/16

AG

Indirects --> awesome but can be hogs for performance, stability.

v lookups --> trash
Index match (or index match match) --> winning

aezmvp

Joined: Oct 25, 2004

Posts: 6,653

User Profile Ignore User Stop Ignoring

How long do you want to ignore this user?

24 hours One week Permanently Cancel

10:40p, 5/23/16

There are a number of Excel forums that discuss that stuff. Rib is yelling about her pregnancy or I'd link them.