when would you use Hlookup or Vlookup over Xlookup
incoming intern with a stupid excel question, sorry if im missing something
Trending Content - Investment Banking Forum
| +394 | Female bankers doing brand deals on TikTok (@emlywang) | 119 | 2h |
| +136 | UBS rolling out Enhanced Clean Desk Policy, bans deal toys | 16 | 1d |
| +76 | Starting FT in a city 3 hours away, dad has progressing Parkinson's. Looking for advice. | 6 | 1d |
| +67 | JULY 2026 CHICAGO BANK RANKINGS | 26 | 10h |
| +64 | Restructuring is paradise (a completely unbiased account) | 6 | 2d |
| +35 | Handling frustration | 5 | 2d |
| +35 | Not Treated Well by Other Interns | 20 | 15m |
| +29 | Taking days off as an intern | 13 | 27m |
| +28 | Thoughts on Intrepid - Houlihan Merger | 10 | 1d |
| +27 | Best books to read as a student/intern | 12 | 3d |
Career Resources
Bump
You don't
index match always
Okay great that makes more sense
Xlookup > Index match for simple searches, I.e. searing just one column or one row. Index match > xlookup when need to search both column and row.
The xlookup syntax is much simpler and cleaner and can be done in less time than index match. I only use index match for complicated tasks
BEHOLD MY 20GB SPREAD SHEET WITH ONLY XLOOKUP FORMULAS.
Everyone uses index match no point in reinventing the wheels. xlookup is better but ur not gonna change the way the group does things as an intern
Do not use Xlookup. Will fuck up your excels and make the file size cartoonishly large. Also can cause issues with people running older versions of excel. Index match does everything xlookup does and is arguably (definitely but i’m lazy) more dynamic.
Depends if it’s the first date or not
I always used xlookup for looking for one thing in one row/column. Use filter if you want to search by multiple criteria (vertical and horizontal).
Index is the only answer
Echoing others, index match > v/h lookup > xlookup in terms of impact of formulas on file size and calculation speeds.
Another cool “party trick” which is very size-efficient is using matrix multiplication which can take logicals in consideration as well using nested sum() functions eg:
Summing cashflows between dates:
Sum( sum(CFS) * sum(datearray >= date) * sum(datearray= date) )
Nesciunt est voluptate eum consequuntur ex. Dolore perspiciatis rerum vero nihil aut. Explicabo consequatur molestias mollitia non numquam eligendi. Placeat magni enim possimus atque totam ipsam minima. Modi cum est maiores sint eveniet assumenda ut. Earum ipsam dolore nobis reprehenderit ex commodi fugiat.
Ad aperiam accusamus perspiciatis facere quo sed maiores distinctio. Eum fugit facere magnam id in. Quis alias voluptas nihil et sit consectetur. Quia non eos voluptates quidem id fugiat reiciendis. Nemo ut nostrum eligendi impedit exercitationem.
Commodi autem ducimus facere deleniti. Quisquam et eos nihil ea nam minus asperiores. Voluptatem aspernatur sunt molestias eligendi voluptas ut hic veniam. Optio deserunt error ratione commodi esse exercitationem. Dolorem nostrum et quae sunt soluta veniam quia.
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...