Hey,

I am new to the forum and trying to find a way to pick applicable value from the database and put it in the output sheet based on a cell value.

Please refer to my attachment. There are three sheets in my file.

1. Database - It has a list of students name,and the information of subjects they had passed and failed.

2. Interface - User uses this sheet to give his input based on the dropdown menu. For example: if the user wants to see the students passed in English, then he has to select 'English' in subject(B3) and 'Passed' in the Status (E3) in Interface sheet.

3. Output -after the input is given in the B3 & E3 cells of Interface sheet, the output sheet should show the section, name of students.
Pick from database based on cell value.xlsx
But how to make it work in Excel, someone please help me. I am a user of basic excel features but a novice in such complex tasks.

I got just 10 more days to finish this project. I appreciate your quick responses.