Issue with copying index & match formula across columns

  • Hi there,

    I've been using an index & match formula which is working perfectly across the first six columns, but won't drag or copy to the other columns. A #REF! result occurs. I've even typed the formula in manually and get the same result.

    I've searched online for possible causes but haven't found a solution.

    The formula is:


    The formula has three criteria and they are located in column A and rows 13 and 14.

    Please help!

  • This is a 2 ways Lookup, using Index + Match function

    Try to use this modified formula instead :



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!