Excel vlookup not updating
Unfortunately, dealing with data isn't always straightforward.
When learning Excel, most people start with simple, single function formulas.
First, your data has to be set up with the search column in the left-most column of your table.
Second, if you use the approximate match for the range_lookup, the data needs to be organized in ascending order.
This is another part of what has made VLOOKUP so popular is its simplicity.
But once the training wheels come off, you start using different formulas together to create more complex functions using the concept of nesting.