Index Match Match Explained

Published: 05 April 2020
on channel: Michael Belasco
7,531
46

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.


Watch video Index Match Match Explained online without registration, duration hours minute second in high quality. This video was added by user Michael Belasco 05 April 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 7,531 once and liked it 46 people.