• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. F

    Look up a value within a range

    sgmpatnaik, I looked at the file you sent, and that's exactly what I want it to do. I am not familiar with the cell format you used in column C for the tariff. The result comes back as "Rs__" I changed the cell format to "Accounting" and it does not appear to affect the result. However, is...
  2. F

    Look up a value within a range

    NARAYANK991 - I am not sure what you mean by "slabs" How I envisioned the VLOOKUP table would be Column A 0 - 10,000 (10,000 lbs is the maximum weight) Column B would have the associated tariff value - in other words $19 for every value (from column A) between 0 and 1500. This is why I assumed...
  3. F

    Look up a value within a range

    I want to test if a value falls between a range of numbers and then give me the resulting value assigned to that range. This is for a shipping tariff. For example: Weight = 2000 lbs Weight Range Rates 0 - 1500 lbs = $19 1501 - 2500 lbs = $38 2501 - 3500 lbs = $76 I want to look up the...
Back
Top