To group arbitrary text values we can use VLOOKUP function. This function is used to categorize information in accordance with arbitrary text values.

## Formula

The formula to group arbitrary text values is given below:

**=VLOOKUP(value,table,column,0)**

## Explanation

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)

**=VLOOKUP(E5,H5:I7,2,0)**

*Figure 1. Example of Group arbitrary text values*

NOTE

- #N/A error will appear if VLOOKUP fails to find a match.

## Leave a Comment