Excel vlookup not updating
So you double click the lower right hand corner of the cell to populate the formula down, and lo and behold, only half the formulas are working.Solution: Use the to reference lock your arrays before dragging your formula down.Please keep in mind that all of these reasons apply to INDEX MATCH as well, but I will use VLOOKUP syntax in the examples because it is more common. This usually occurs when someone is trying to show a leading zero in front a number.
In this example, we have a VLOOKUP formula that, from a surface view, should work as planned. Yes, there’s an extra space at the end of the input.
The above research paper may not be directly linked to formulas not working in excel, but there is a point here: Very well built & tested software like MS Excel can go wrong in terms understanding our data to recalculate.