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.