Match Cell / Row / Index Lookups are Cached

From Planimate Knowledge Base
Jump to navigation Jump to search

The results of the routine Matched Cell, Matched Row and Matched Index are cached so the next time you do a lookup Planimate will check the last valid result first before searching from the beginning.

So by carefully sorting your lookups you can reduce the number of iterations the engine has to spend searching.



idkbase note 204

Retrieved from ‘https://wiki.planimate.com/index.php?title=Match_Cell_/_Row_/_Index_Lookups_are_Cached&oldid=1744’