From the course: Excel for Financial Planning and Analysis (FP&A)

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Solution: Mapping dynamic data tables to an FP&A model

Solution: Mapping dynamic data tables to an FP&A model - Microsoft Excel Tutorial

From the course: Excel for Financial Planning and Analysis (FP&A)

Start my 1-month free trial Buy for my team

Solution: Mapping dynamic data tables to an FP&A model

“

(lively music) - [Instructor] So how did this challenge go for you? I'm going to be walking you through how I would go about solving it. Let's go down here to F82. I'm going to type in equals X match, hit tab, and here is my syntax. It says lookup value, lookup array, match mode and search mode. My lookup value is going to be this texturing over here, total learning and development labor at A82. Now I'm also going to do a function F4 or F4, depending on the make of your machine. And when I do, you'll notice that it adds in these dollar signs. This converts a relative reference that allows the formula to move all over to turning it into something that is absolute or locked. If I were to copy $A $82 anywhere, it's not going to move off of this cell. I'm going to hit it again and again one more time so that it absolute locks my column and gives me a little bit more flexibility for my row. When I hit comma, it says, look…

Contents