3rd parameter in LOOKUP function can be skipped in Origin 2026 to return row index, so you can use it to do many tasks without need to try many different functions such as index, list, table, match, search, etc.
originlab.com/doc/LabTalk/re…
E.g.
* find a string/number in a column and return row index or corresponding value in another column.
* When finding number, the column doesn't need to be monotonic
* When finding number, use 4th parameter to specify finding nearest value, nearest value smaller than or larger than the number.
Learn more and download a free trial at
originlab.com/2026
#originpro #originpro2026 #originlab #DataAnalysis #DataVisualization #formula #lookup