Related Posts
What is the notice period in ihs markit?
Additional Posts in Investment Banking - IBD
Does IB coverage or M&A team pay more at a BB?
Any take on culture of MS Menlo?
How’s WLB and comp in EVR’s PCA group?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
If one of my analysts or associates used a x or vlookup, I’d literally restaff the project.
Everyone uses index match
I think of XLOOKUP as a better VLOOKUP and index and match as superior to both
Hmmm okay I’ll do more research, thanks!
Index match is the best out of the 3, and quite straightforwarx once you get the hang of it. Highly recommend
Index match logic makes more sense to me than vlookup
Subject Expert
Index match is superior! Learn it and it will be more useful on those late nights!
Subject Expert
Also I think it’s harder to audit xlookup or hlookups too.
Im a big fan of x lookups but stick to index match in live models because i dont wanna get yelled at lol, plus also concerned that there could be a backwards compatibility issue for older excels without x lookup
What can index match do that xlookup can’t?
Not that it can’t do things index match can’t, it’s more convenient and conventional to just stick to what works/was reliable with huge convoluted databases.
Hello