Index Match Match Explained

In this video, I walk you through how to use the Microsoft Excel function Index Match Match.

The video is quick and to the point and is accompanied with a downloadable template that you can follow along with on our website, www.AdventuresInCRE.com. Link is below.

Index Match Match allows a user to pull a specific cell value from a field using both a header and column reference to hone in on the specific cell. In our example, we use my Basic Hotel Proforma where I take the annual values from a detailed proforma with extra columns and pull only the numbers out from specific columns so we can look at a simple annual cash flow without all the noise.

The link to the post where you can download the template is here:

https://www.adventuresincre.com/index...

For more great content and free tutorials on real estate financial modeling and so much more, please visit www.AdventuresInCRE.com.