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.
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.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks