Anchoring cells in Excel exercise

Please sign up for the course before starting the lesson.

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

Back to: Vlookup Explained- 1 Hr > VLOOKUP Exact Match