Hi for some reason my vlookup formula works but doesnt refresh is i change a value in a cell. Sheet is auto calculating. Some other users have had same problem and found index and match to solve it.
Is it possible to convert this formula to index and match. Never used it before.
If so could someone post up an example. ThanksPlease Login or Register to view this content.
Bookmarks