I would like a formula in cell F24 that searches column AD60:AD130 for specific text "Team Averages:"
If "Team Averages:" is found in AD then return value listed in that row in column AT. I have searched all over internet and can't find the formula for this. Can someone assist me?
If "Team Averages:" is found in AD then return value listed in that row in column AT. I have searched all over internet and can't find the formula for this. Can someone assist me?