A useful feature of VLOOKUP is its ability to anchor cells. A common problem is that data appears in different cells at different times (each time you download a report a key cost item you are looking for appears on a different line). You can use VLOOKUP to find the cost item and make it appear on a set row. You can then build ratios and graphs off this static row
Anchoring cells in Excel exercise
You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.