For some reason my vlookup formula in the Weight Category column is not working because I keep getting #N/A errors
I think my look up table titled BMICategory might be wrong. It has to meet these categories:
Underweight = less than 18.5
Normal = 18.5 or greater and less than 25
Overweight = 25 or greater and less than 30
obese = 30 or greater
Thank you.
Last edited by BillJo; 03-28-2015 at 02:29 PM.
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.
since it is a small table you could use this:
Please Login or Register to view this content.
Hi,
I already have TRUE
=VLOOKUP(E4,BMICategory,2,TRUE)
In B7 my copy of your file shows
=VLOOKUP(B6,BMICategory,2,FALSE)
Oh I am sorry the vlookup that I am referring to is in the CurrentData spreadsheet with the look up table in BMICategories spreadsheet.
Thanks
Your table is wrong. The values in the first column should be the lower boundary of that range - i.e. the first value in B should be 0 and the others should shift down 1, excluding your duplicated 30 value.
Everyone who confuses correlation and causation ends up dead.
Here is what Rory means,
Oh, I see thank you.
On my CurrentData spreadsheet in Column d for example it says M for male but the corresponding G or H column is not right.
The formulas are returning male results for females and females for males.
How would I update the formulas?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks