Which formula can I use to pull data from one sheet to another with multiple criteria?

The above image is from one sheet. From this sheet I would like to pull the text from the Answer column into the "2.3.3" column in the below image. I tried using Index/Match and it worked for one question number but when there are multiple question numbers for the same school and SCID, I'm not able to only pull the answers for that school. For instance, in the top image there is another question number for that school with a different answer. Then below that there is the same question number for a different school with a different SCID (not shown in the image). I'm trying to use a formula to fill in the answers for each corresponding question number in the image below. I hope I explained that in a way that makes sense. Thanks in advance for any help you can provide.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!