=IF(Results!C1=Picks!B94,(VLOOKUP(C1,scores,2,FALSE)), "")
I feel like I'm on the right track with the above code, but I need "Results!C1" to equal any cell from a range instead of just cell "Picks!B94" (i.e. B94:G94). Any help would be greatly appreciated. I have attached the spreadsheet as well.

Book1.xlsx