The following is an example that demonstrates how to return data in a corresponding cell if matches in a range of cells.

 

Lookup from a different sheet:

From the same sheet:

 

 

Example:

 

Download example