Dealing with Errors in Lookups

Dealing with Errors in Lookups

The #N/A Error If we use the VLOOKUP Function to match between two sets of data – then occasionally, Excel will return an #N/A error where it can’t find the value in one list in the other one In this example, we have two lists of employee data where in the...
Case Study: Hyde Community College

Case Study: Hyde Community College

  The Client’s problem Hyde Community College (HCC) is a secondary school in Tameside with almost 1,000 pupils. In common with many commercial businesses, HCC makes extensive use of data; analysing, amongst other things, pupils’ performance data in assessments...
Comments in Excel

Comments in Excel

Making your spreadsheet understandable and easy to update For many of us, building a spreadsheet can be a one-off exercise to answer a specific issue or calculate a value. However, for others, spreadsheets can be designed to capture a year’s worth (or more) of...

Pin It on Pinterest