I've always used vlookup but, I've recently heard a lot of colleague say Index-Match was better - calculates faster and is widely used in the industry. However, I just read an article stating that prior to being president, everyone knew Donald Trump's preference for vlookup.
Considering his career success, should I give vlookup further consideration to incorporate in our firm's model to match potential acquisitions with comp sets?
| +83 | LP coming into deal at higher land basis. How to model returns to GP? | 19 | 22h | |
| +76 | Increasing RE Industry's Cash Compensation, Collectively | 43 | 2d | |
| +73 | Major Decisions | 13 | 2d | |
| +44 | Being asked to stay behind and train my replacement | 11 | 19h | |
| +24 | Thoughts on joining an early-stage REPE fund | 7 | 1d | |
| +22 | Self Storage ECRI | 9 | 4d | |
| +20 | How to get good at RE Modelling? | 18 | 20h | |
| +20 | Public Homebuilders | 7 | 18h | |
| +18 | What does REPE actually do? | 1 | 23h | |
| +18 | 3 Hour Condo/Rental Excel Test - What Can Be Expected | 2 | 5d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Maybe try =FAKENEWS() or =FALSE(). If these don't work, go for =IF(YOUR'EFIRED,1,0)
Sumproduct >Index&Match>Vlookup
Just use index match. Faster yeah but you won't notice much of a difference in most models. To me the best benefit is you can look up values to the left of your lookup value...or in any direction for the matter. Vlookup limits you only to the right of the lookup value in the arrayed table.
You ever done an index match match? Will blow your mind.
It's bblloowwwwnnnnnnn
I use index match, but I just made a VBA function to make it a bit more intuitive to use.
Edit: Had a couple of requests for the code. The link to the code is below, and I've also included Index match match.
https://pastebin.com/XR89cFUk
Index matches can slow down a model if you get too many. It's like a shot of bourbon. Too many and you're going to break something,
Index-Match pretty much makes Vlookup completely unnecessary, and it's more versatile. I'd recommend just practicing with it a bit and you should pick it up quickly. Very useful for general data analysis in Excel.
HAHA what is with the serious Stack overflow-like responses?
Facere ut repellendus quis accusantium modi commodi. Cumque quaerat est facilis aut. Aut quis animi quo quidem omnis enim quaerat rerum.
Et minus sed nemo dolores est commodi est. Culpa et quia sint facilis. Quo possimus aut cupiditate delectus quos.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...