Quote:
Originally Posted by CMoHorn
I am working on an inventory spreadsheet. The formula I need help with is IF("VLOOKUP VALUE") is between 1-19 then "LOW"; IF "VALUE" between 20-49 then "MEDIUM"; IF "VALUE" between 50-74 then "HIGH"; IF "VALUE" = 75 then "HEAVY".
I hope that makes sense. Thanks.
|
Would the VLOOKUP values always be whole numbers or could they be decimals too?
If always whole numbers then a simple VLOOKUP table would work.
If decimals then a long winded IF AND nested formula would be needed.