Question

what is the classification of ms Excel

Answer 1

When you want a test field based on certain lookup value. VLOOKUP() is your option. 

VLOOKUP requires below shown arguments



You need to have one more table where first column contains your criteria and rest all are your data to be pulled. 
In your case you need two columns only first column would be combination of all sub groups. and second column will be Group Name

There are in all 72 possible combination probably much less as per medical conditions. 




Once you are ready with all required criteria in other table, I have placed table in sheet 2. Insert this =VLOOKUP(C2&" "&D2&" "&E2&" "&F2&" "&G2,Sheet2!B2:C73,2,0) in Classification cell




As you can see all five criteria are combined in lookup value using & and spaced by " ". 

You may also use CONCATENATE() instead of&

Congratulation you have successfully classified data based on multiple criteria with 2D VLOOKUP()

To learn more on simple yet advance use of Excel join Linkedin group "Excel for Engineers"

please mark as BRAINliest answer