< Go Back

Group arbitrary text values

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.

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar