Lookup across multiple sheets Add-In is a custom function that let´s you lookup a value or multiple values and return multiple values or rows from multiple sheets.

Features

Easy-to-use custom function
Lookups across multiple sheets
You can use multiple search values at the same time
Use wildcards to refine your searches even further
Up to 127 multiple ranges or sheets
Returns all values or rows
Returns unique distinct values or rows
Returns duplicate values or rows