• 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

    Please help with value look up and match from two tables

    Hi Bosco and Siga many thanks for both of your help. Bosco's formula works perfectly for what I asked for however I realise now what was missing in my question. Take the first line for example, the rate returned is 2.9. The answer I was looking for is actually 2.5. This is because i wanted...
  2. S

    Please help with value look up and match from two tables

    Ok, let's try again. I have simplified the table and see if this makes more sense. Thanks!
  3. S

    Please help with value look up and match from two tables

    Hi Ashokkumarkolla Many thanks for your quick reply and the tip to upload the file instead of the image. The formula would only work if it is a one-on-one match however if I change the order of the data in the table on the right hand side, it would not work. It will have to be something like...
  4. S

    Please help with value look up and match from two tables

    Hi I'm new to this forum (the only forum I have ever joined) and i hope to learn a few things to improve my excel skills. I'd like to get help with a formula that does this please Also, if you are able to provide the VB codes for this that'd be even more awesome. Many thanks in advance...
Back
Top