btw you can use vlookup in an arrayfunction and then use curly brackets for each column you want to return. In this case, I returned columns 5,6,7,8,9,10, and 15. It will return the result for each row specified, in this case the rows are a named range called Team1.