Nesting an “IF” statement into a working formula

Hello, I need help nesting an “IF” statement into a working formula. The sample Excel file contains 3 worksheets: Main, Staff, and Appraisers. The Main worksheet has a drop-down list of Regions (01, 02, 03, etc.). The Staff worksheet has columns for ‘Names’, ‘Country’, ‘Region’, and “Status”. The Appraisers worksheet has a column called ‘Names in Region’ and the cells in that column contain the formula like this one for cell A2:

Please Login or Register  to view this content.

When a Region is selected from the drop-down list in the main worksheet, this formula will look in the Staff worksheet in the ‘Name’ column for all names with a corresponding Region number that was selected on the Main worksheet and place them in the ‘Name in Region’ column in the Appraisers worksheet.

What I need to do is modify this formula so that it in addition to listing names with the selected region number, only names with a corresponding ‘Status’ of “Current” are listed.

I’ve tried for hours, but to no avail. I hope someone can help me out. Thanks in advance.

Thanks, azumi. Works perfectly. Happy Thanksgiving.