Categorize data in excel- exercise 2

Free Preview

Another example in using VLOOKUP approximate match to categorize items in Excel.

In the file you downloaded look for the sheet name ‘VLOOKUP-Catergorise-2’

In this example, you need to group your employees into various age categories for your reporting.

  • In E14 column, create a lookup the compares the age in column D, to the table in A4 to B8 and brings back the relevant description, e.g. an age of 36 would return ‘Between 35 and 50’

Video Instructions

To follow along go to 5_2_1

Video Solution

To follow along go to 5_2_2

Back to: Free VLOOKUP Course > VLOOKUP Approximate Match