To group arbitrary text values we can use VLOOKUP function. This function is used to categorize information in accordance with arbitrary text values.
The formula to group arbitrary text values is given below:
VLOOKUP formula operates the value which we insert in any cell of excel spreadsheet. In place of “table”, we insert a range of lookup table while in “column” number of column is inserted. “0” point out precise counterpart.
The example given below contain different department inserted in column E while sections are inserted in column F. Lookup table contains different departments and their specific sections. Formula inserted in F5 is given below: (See screenshots)
Figure 1. Example of Group arbitrary text values
- #N/A error will appear if VLOOKUP fails to find a match.