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

    Using VLOOKUP to find value to the left

    That did it Luke. Thank you. I swear I tried the Index + Match combo, but, obviously, I was doing it incorrectly. Good day.
  2. K

    Using VLOOKUP to find value to the left

    Thanks for the responses. I looked into the OFFSET function and it doesn't appear to be what I'm looking for. Neither does sorting. If I wanted to find the payoff date, then I could simply scroll down and find where the End Balance is less than or equal to zero. However, what I'm trying to...
  3. K

    Using VLOOKUP to find value to the left

    I am lost on this one and have searched and found several solutions to use the VLOOKUP idea to find something to the left, but not one that will work for me (i.e. INDEX + MATCH, VLOOKUP + CHOOSE, and a few others). Here's the situation: I have a debt amortization table and would like to use a...
Back
Top