https://community.esri.com/t5/arcgis-pro-questions/expressions-in-arcgis-arcade-have-the-same/m-p/1110146#M47036 <LI-CODE lang="javascript">// SortField: Field to sort the feature set by, e.g. ObjectID var sort_val = $feature.SortField var fs = FeatureSetByName($datastore,"YourFeatureset", ["SortField", "ValueField"]) fs = Filter(fs, "SortField &lt; @sort_val") if(Count(fs) == 0) { return $feature.ValueField } return First(OrderBy(fs, "SortField DESC")).ValueField</LI-CODE> Fri, 22 Oct 2021 08:17:26 GMT JohannesLindner 2021-10-22T08:17:26Z https://community.esri.com/t5/arcgis-pro-questions/expressions-in-arcgis-arcade-have-the-same/m-p/1110092#M47029 <P>Hi All,</P><P>What expressions in ArcGIS Arcade have the same function as Indirect Expressions in excel?</P><P>Please see the illustration below:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Capture143.JPG" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/25842iB5F619F28B442AE3/image-size/medium?v=v2&amp;px=400" role="button" title="Capture143.JPG" alt="Capture143.JPG" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Capture143.JPG</span></span></P><P>&nbsp;</P> Fri, 22 Oct 2021 04:03:18 GMT https://community.esri.com/t5/arcgis-pro-questions/expressions-in-arcgis-arcade-have-the-same/m-p/1110092#M47029 bhariadi 2021-10-22T04:03:18Z https://community.esri.com/t5/arcgis-pro-questions/expressions-in-arcgis-arcade-have-the-same/m-p/1110146#M47036 <LI-CODE lang="javascript">// SortField: Field to sort the feature set by, e.g. ObjectID var sort_val = $feature.SortField var fs = FeatureSetByName($datastore,"YourFeatureset", ["SortField", "ValueField"]) fs = Filter(fs, "SortField &lt; @sort_val") if(Count(fs) == 0) { return $feature.ValueField } return First(OrderBy(fs, "SortField DESC")).ValueField</LI-CODE> Fri, 22 Oct 2021 08:17:26 GMT https://community.esri.com/t5/arcgis-pro-questions/expressions-in-arcgis-arcade-have-the-same/m-p/1110146#M47036 JohannesLindner 2021-10-22T08:17:26Z