Digitizing Your Classroom Library System Step 4: Creating a Basic Info Page

Step 4: Creating Basic Info Page, this episode will walk you through how to create a page that curates all the data you have exported into one. Difficulty Level 2: "Intermediate"
**Be sure to use the exported file from Step 3**
Formulas:
1. =vlookup($A2,Shelves!$A:$K,2,False)
2.=countif(Shelves!A:A,A2)
3. =if(N2=0,"",A2)
If formulas are not working, please make sure that the columns match up or leave a comment below.