Hi BillJo,

You need to change the False to a True in the last argument of the VLookup function. Try

=VLOOKUP(B6,BMICategory,2,TRUE)

False means an Exact Match while True just means in that range.