See what we can offer to your school
"SimpleStudy just makes sense...”
Get the best plan for your school
10 cards from this deck
Analyse data quickly and efficiently
One IF statement placed inside another IF statement
In sequence, as a hierarchy of conditions
Formulas tab in ribbon, fx icon
Searches vertically down first column for a match
lookup_value, table_array, col_index_num, range_lookup
Searches horizontally across top row for a match
VLOOKUP for column data, HLOOKUP for row data
Use FALSE for exact match to avoid unexpected results
Student grades, inventory prices, employee details
Select your subjects, and get access to A+ resources today.