Search and import data from excel under some rules.

[nwpulele]

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.

[nwpulele]

Question solved by myself.

[supputuri]

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