• 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. S

    HLookup - next largest value

    I am having trouble returning the next highest value using HLOOKUP. For example: My table array (data) = 10, 20, 30, 40, 50 If my lookup value is 34, HLookup returns 30. I would like it to return 40 (round up instead of down). Any help would be greatly appreciated
  2. S

    Uni Assingment help - matching prices for shopping items

    Hi everyone, I am doing some excel analysis for a university assignment, and I would be very grateful of any help on a problem I have. The analysis basically has 2 data components to it: The 1st part, is a basic transaction list of shopping items bought through the year. Each transaction's...
Back
Top