FINDROW
Searches a column in another sheet and returns either the found row number or a value from another column on that same row.
FINDROW is the lookup formula for TableStudio sheets. Use it when you want to search a source sheet by a key and bring back either the matching row number or a related value from that row.
The syntax is =FINDROW(value,column,sheet,offsetOrColumn,ifNotFound). value is what TableStudio searches for. It can be text such as "R001", a cell reference such as A2, or another formula result. column is the source column where the search happens. It can be a letter such as A or a zero-based index such as 0, where A and 0 both mean the first source column.
sheet is the source sheet reference. In the main workbook you usually use SH1, SH2, and so on. In TOBJ or object-editor workflows you can also use explicit scope such as WB:SH2 for the main workbook and OBJ:SH1 for the current object workbook.
If offsetOrColumn is omitted, FINDROW returns the found row number using TableStudio's 1-based row numbering. If a number is provided, it works as a column offset from the search column: 0 returns the search-column value itself, 1 returns the next column to the right, 2 returns two columns to the right, and -1 returns the column to the left. If a column letter is provided, such as G, FINDROW returns that absolute source column from the matched row.
FINDROW returns the first exact match it finds in the chosen source column. If no match is found, the result is #N/A unless ifNotFound is provided, for example =FINDROW(A2,A,SH3,G,0). Invalid arguments produce #ERR. If the return column points outside the available source columns, the result is blank.
In Lookup key mode, TableStudio stores the chosen key directly and writes FINDROW formulas for the dependent fields. That keeps linked values stable even if rows are inserted above or below in the source sheet later.
Function
FINDROW(value, column, sheet[, offsetOrColumn[, ifNotFound]])
Parameters
- value — The key to search for. It can be text such as
"R001", a cell reference such asA2, or another formula result. - column — The source column where the search happens. It can be a letter such as
Aor a zero-based numeric index such as0. - sheet — The source sheet reference, such as
SH2,WB:SH2, orOBJ:SH1. - offsetOrColumn — Optional return target. Use a numeric offset from the search column, or an absolute source column letter such as
G. - ifNotFound — Optional fallback value returned when no match is found. If omitted, FINDROW returns
#N/A.
Returns
Returns the first matching row number when the return argument is omitted, or the value found at the requested offset or absolute return column. When ifNotFound is provided, that value is returned instead of #N/A.
=FINDROW("SBET",A,SH2) returns the 1-based row number of the first match.
=FINDROW("SBET",A,SH2,2) returns the value two columns to the right of the matched A column cell.
=FINDROW("SBET",A,SH2,C,0) returns column C from the matched row, or 0 if no row matches.
Return the found row number
When the return argument is omitted, FINDROW returns the 1-based row number of the first matching source row.
Return a related value by offset
Set the offset argument to an offset from the search column when you want another field from the same matched row.
Stable lookup with a stored key
Lookup key mode stores the selected code and writes FINDROW formulas for dependent columns, so source row moves do not break the link.
Enable JavaScript to use reading progress and usefulness ratings.