Results 1 to 2 of 2

Thread: Index/match issue

  1. #1

    Index/match issue

    Register for a FREE account, and/
    or Log in to avoid these ads!


    So I have created an excel document with various sheets in it. Sheet1 has various formulas in it using the MATCH INDEX function to draw values from tables in the other sheets. The table from which some of the values are being drawn (on sheet2) has a column with varies piping classes on it such as FC2, HC1, GC3 and LD3. along the top row it has pipe sizes. The table is completely filled in. On sheet1 when I use th INDEX MATCH functions to draw the correct values from sheet 2 it works for nearly every piping name, but not some of them. I am not changing the equation in anyway, just changing the name in th cell which needs to match.

    Can anyone explain why this happens?


  2. #2
    Conjurer Beamer's Avatar
    Join Date
    Nov 2014
    Excel Version
    Hi t-pot253, without seeing a sample sheet and your formula, my guess would be that your MATCH isn't looking for an EXACT match.
    Could you post a small sample sheet with say just that table and your lookup formula?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts