New answers tagged worksheet-function
I suggest simpler merely to add a 0 into the From cell for Severely underweight, then: =INDEX(Name,MATCH(B2,From)) to avoid the IFERROR function (which in @Lance's answer may not be working as intended - maybe INDEX(Name,2) rather than INDEX(Name,1,1) if to avoid adding 0).
With the A value (eg "name1") held in say C1 and the B value (eg "yes") in say D1 then: =COUNTIFS(A:A,C1,B:B,D1) is shorter and more versatile.
A formula like this: =vlookup(A1,Sheet2!A:B,2,0) copied down in your first sheet may serve.
Top 50 recent answers are included