• 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

    Do I need to use Offset Match? Or Index Match?

    Thanks for the help everyone. Awesome formulas! I like these better than mine.
  2. S

    Do I need to use Offset Match? Or Index Match?

    Hui, I found a solution that seems to work. If anyone has something better please let me know. I created dynamic ranges for the columns containing zip codes. (ZipCode1, ZipCode2, etc.) Then used an IF statement to find the column it is in with an array entered formula. Here is a very...
  3. S

    Do I need to use Offset Match? Or Index Match?

    Hui, Thanks for looking into my problem. I will see if I may post a sample file. In the meantime...The zip code is in one of three columns. It may reside in column AX or column AZ or column BB. Again thanks for the help!
  4. S

    Do I need to use Offset Match? Or Index Match?

    Greetings! I have a workbook where the user enters a zip code into cell C4. I need a formula in cell D4 to look up that zip code and return the cell in the next column. My problem is the zip codes are in columns AX, AZ, and BB. I tried to start with the following but it returns a #VALUE...
Back
Top