Questions Tags Users Badges

Importrange and dropdown box

user_16599069 0

Created Aug 5, 2021 Edited Aug 5, 2021

Viewed 53

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

dropdown google-sheets-formula import xcode

1 Answers

=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")

edited Aug 5, 2021

user_161251390

answered Aug 5, 2021

Related