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’
To follow along go to 5_2_1
To follow along go to 5_2_2