Excel vlookup not updating
The V in its name conveniently stands for vertical, which means the formula will search for the criteria vertically in the first column of the data.
(Note: Excel has another function, the HLOOKUP, that does the same thing, just horizontally.) The VLOOKUP formula works if your data is organized vertically and the search column is the left-most column.
The VLOOKUP formula uses what's known as a static column reference.Since VLOOKUP references are static, you typically have to count the number of columns in your table to get to the results you’re looking for.This is the adult version of counting on your fingers.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.