Search, Search..

[Frank Bacchus]

Attached is workbook consisting of a criteria sheet, a data sheet & a results sheet. I would like to find the suggested resolution in search criteria. The data composed of several columns, which are the same on multiple sheets that I would like to search for specific text in any of the sheets (max 5). The result would be provided, on the results sheet and consist of (1) the field I am searching for, (2) the row number when the data is found and (3) the sheet name (see Results tab)

Thanks and I appreciate it

frank

 

[rahulshewale1]

hii @Frank Bacchus ,

You can achive desire output Using Power Query with Easy way ..

Pfa attached Sheet ..with Three criteria.


Regard
Rahul shewale