Match Value in Sheet Column

Quickly search down an entire column of a SIMUL8 spreadsheet and return the first row that exactly matches a specific numerical value.

Parameters

  • Sheet location of top of the column to search eg MySheet[5,2] will search down column 5 starting at row 2
  • The numerical value to find
  • A data item (global or local) to receive the returned row number of the located row

If the value is not found then row is returned as -1. Non-numerical cells are not considered (for example blank or text).

Related Commands

See Also