Excel 2007 : Map Serverwise Apps Name from one sheet to another

[piyushtataria]

I am working on an 2 different sheets.

Sheet1 Contains the Name of the servers (column A) and the applications(Column B) running on it.
Sheet2 Contains the name of the applications and the status (Active/Inactive/Decommisioned)

I need to map from Sheet2 all the applications with sheet1 applications (column B)

The objective is to find out which applications in Sheet B are Running on Servers in Sheet A that are Active / Inactive / Decomissioned.

Can some one please help me with what formula can I use and how do I use it to achieve the results?

[tlafferty]

Sure - please post a sample book.