Forum Discussion
Solved
If Then Statements Across 2 Spreadsheets
Every semester our school gives us a big report of class grades but I only need to track some students and classes. How can I set it up so I can match students names and classes and return specific g...
With a layout like this:
In B2 on Spreadsheet 2:
=IFERROR(INDEX(Sheet1!$C$2:$C$200,MATCH(1,(Sheet1!$A$2:$A$200=$A2)*(Sheet1!$B$2:$B$200=B$1),0)),"-")
If you don't have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter.
Fill down, then to the right or vice versa.
See the sample workbook below.
As variant you may create PivotTable with measure
Grades:=CONCATENATEX(Range, Range[Grade] )and use slicer for filtering