Hello to all
I would like to here your opinion about the VLOOKUP vs INDEX/MATCH function.
Is one faster than the other, what is the difference, and what it will be the criteria to use one over the other?
I have a sheet with several VLOOKUP formulas, it takes a long time to get updated also when I save it takes a long time what causes this, any way to remedy this?
Thank you
All
John
I would like to here your opinion about the VLOOKUP vs INDEX/MATCH function.
Is one faster than the other, what is the difference, and what it will be the criteria to use one over the other?
I have a sheet with several VLOOKUP formulas, it takes a long time to get updated also when I save it takes a long time what causes this, any way to remedy this?
Thank you
All
John