Importrange and dropdown box

Question

I have 4 separate spreadsheets SpreadSheets1 - Student 1, spreadsheets

• Student 2, spreadsheets
• Student 3, spreadsheets
• Master. In the master sheet, I have a Dropdown list with Student1, Student 2, Student 3,in C2 when I select student 1 in drop-down box C2, data in D2 & F2 of master should go to spreadsheets 1 - Student 1 F & G Column, please help https://drive.google.com/drive/folders/1J-W7p9SmK8pamApYmxlOWbnM6XmmyB4m?usp=sharing Thanks in advance

Answer 1

=FILTER({IMPORTRANGE("https://docs.google.com/spreadsheets/d/1-MMV9GrJi0yj23xyYB84Fqt4LwxzegH8qDkLmg2tlbE/edit","Sheet1!D:D"),IMPORTRANGE("https://docs.google.com/spreadsheets/d/1-MMV9GrJi0yj23xyYB84Fqt4LwxzegH8qDkLmg2tlbE/edit","Sheet1!F:F")},IMPORTRANGE("https://docs.google.com/spreadsheets/d/1-MMV9GrJi0yj23xyYB84Fqt4LwxzegH8qDkLmg2tlbE/edit","Sheet1!C:C")="Student 1")