Micro Focus QTP (UFT) Forums

Hi All,

I'm a QTP beginner.

I'm wondering if there is a way to search and import data from an Excel sheet under some specific rules.

For example, I need to search value "123" under A column. Once found, for example, at "A2" cell, I need to import "A2" and "B2" cell to QTP datatable.

Sometimes, I need to search value like "456" under A column. If it is found at "A3", I need to import "A3", "B3" and "C4".

I'm wondering if it is possible to do this.

Thank you.

Question solved by myself.

please post the answer so that it would be helpful for other folks.