SPEED QUESTION: EQUAL v. VLOOKUP

Mr_Phil

New Member
Joined
May 28, 2018
Messages
2
Which is faster?

I have two workbooks. One has all the personnel information and the other has equipment information. They team up to create picking sheets for the warehouse. Each provides information to the other one via vlookups.

I was wondering if instead of doing a vlookup I could simply write =otherworkbook!$etc. To do that I would have to stabilize the data tables so that the data remains in the same place. But, that is not really a problem. I don't have anyway to test it across over 75K vlookups. That's why I am asking y'all. It always pays to know people who are smarter than you.

Thanks for looking
 

RasGhul

Well-known Member
Joined
Jul 15, 2016
Messages
606
Index & Match is much faster than Vlookups. Index & Match compares only 2 columns & can look left for match value, Vlookups must scan your whole data set for your match value and can't look left only right.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,113
Office Version
365
Platform
Windows
Setting one cell equal to another like =Sheet1!A1 would be quicker than using a lookup.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,146
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Last edited:

Mr_Phil

New Member
Joined
May 28, 2018
Messages
2
Also, please take a minute to read the forum rules on cross-posting and follow them in future. Thanks.
Noted. Apologies to all. I thought creeps posting only applied to sub forums within the same board. I reread the part you mentioned to include the explanation of why it is frowned upon. I won't do it again.

Thanks again to everyone for reading z and helping out.
 

Forum statistics

Threads
1,077,636
Messages
5,335,387
Members
399,015
Latest member
emalabel

Some videos you may like

This Week's Hot Topics

Top