What formula (between these two formulas) would use more system resources?

[dikken20]

Hi,
My excel file calculation takes too long, I've been told to change to different formulas in order to use less system resources, thus, calculation will take much less time to run.

Which of the following formulas uses less/more system resources:

=INDEX(Sheet1!$C$2:$G$600,MATCH(M2,Sheet1!$C$2:$C$600,0),5)

or

=VLOOKUP($M2,Sheet1!$C$2:$G$600,5,FALSE)

?

 

[RoryA]

Assuming you need to return more than one of "Last price, High, Low, Volume, Change, etc,.." for a given stock identifier, then yes, you should use one MATCH formula and several INDEX formulas.

If sheet1 is, or can be, sorted on column C, then the double vlookup will be a lot faster than your initial VLOOKUP because it will not have to search row by row. Note that it does not use the fourth FALSE argument.