Wall Street Prep

XLOOKUP is Magic: Using XLOOKUP to Generate Multiple Values

In this lesson, you'll learn how to use XLOOKUP to generate multiple outputs at once, without having to create multiple XLOOKUP formulas.

Using XLOOKUP to Generate Multiple Values

Below is a short tutorial on using XLOOKUP to instantly generate multiple values with just 1 formula.

Download the Excel file that goes with this lesson below.

Submitting ...

Turbo-charge your time in Excel Used at top investment banks, Wall Street Prep's Excel Crash Course will turn you into an advanced Power User and set you apart from your peers.
Learn More
Comments
guest
0 Comments
Inline Feedbacks
View all comments
X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.