Index and Match Formula
Just having some observation in the index and match formula that I used (data captured is from another file). Seems like the value of the formula only updates when I open the said file, then I'd need to save the file as soon as the values of the formula are updated. I noticed it because this column with the index match formula produces data w/c i use as basis in sorting a particular category to generate a list via a Report File. The report file is then published to a dashboard. Every week when the updates are expected to create a change in the list, the list in the dashboard does not change not until I open the grid file with the index match formula so that the data captured by the formula updates. Is it better to use the Vlookup formula instead?
Help Article Resources
Check out the Formula Handbook template!