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

    Multiple IF Statements across multiple cells based on a LIST in Column A

    Thanks SirJB7 and Hui, I think you have given me the answer I was looking for, I'll give the Vlookup formula. Many thanks again to you both, it is appreciated. All the best, Weg
  2. W

    Multiple IF Statements across multiple cells based on a LIST in Column A

    Hello Hui, many thanks for your prompt response. I've revisited my spreadsheet and I'm now trying this new approach and could do with some of your wisdom as I'm trying for the 1st time a multiple IF statement! Based on selection in A1 (ie: ABC), then B1 needs to be 123, C1 needs to be 321...
  3. W

    Multiple IF Statements across multiple cells based on a LIST in Column A

    Hello, this is my 1st post so please be gentle! I have successfully created a LIST which is used down multiple rows in column A. Based on the result of the LIST selection say in A1, I need to then insert a NUMBER into B1, and then based on the result of B1, populate a NUMBER in C1. Example...
Back
Top