This site requires JavaScript to be enabled


Dear Tricentis qTest users,

If you would like to submit a Tricentis qTest ticket,

please use this support request form.

Tosca Version
IncidentLookup using list
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
Finds a match if both terms exist in a document (an intersection of sets).
NOT, minus (-), or exclamation point (!)
Excludes documents that contain the term after NOT (a difference of sets).
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
Quotation marks (")
Use quotation marks to search for an exact phrase with multiple terms.
For examples and more information look at our Knowledge Base: Advanced Search On The Support Portal

How to get row data and the row number for any column value in excel table

This article explains how to get row data and the row number for any column value in the excel table.


  1. I want to get row data(FirstName, LastName) for a particular ID.
  2. I want to get the row number for a particular column value in the table.

    The table looks like the following:


  1. If you want to get row data for ID =40, you can try to fetch it in the following way using the Excel Engine:


       2. If you want to get row number for the ID =40 (for example),  you would need to first get the rowcount of the table and then use a while loop to verify the value of the ID until the verification fails, that is, when the value of the ID column reaches the desired value, the condition should result to False to exit the loop. You may refer to the following test case:




Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial