Forum Discussion
Formual Error
Trying to create and excel sheet that shows the top 3 tour members for each month of the year but the formula i'm using to show me that information is showing up as an error and i'm confused as to wh...
I don't know what those columns are but I'm guessing the problem is with the @ symbols. That symbol will take only the corresponding line item from the array so you are probably getting a MATCH finding no result and hence the error.
You can/should also consider using XLOOKUP for this
Also this would appear to only return 1 value not the top 3, but I'm guessing you know that and have a similar formula for the other 2?