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).