Avatar of newparadigmz
Flag for United States of America

asked on 

Need Excel formulas to lookup ranges of text based on changing order of rank

The blue section is static info about teams that will sit in another tab. The orange section will be automatically sorted by score and meant to be refreshed and changing in order. I am looking for formulas to put in the green and yellow sections that will always show the contents of the blue sections accordingly to the teams that are in 1st,2nd,3rd place.

I cannot upload an actual sheet so would greatly appreciate just some sample formulas!

Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Rob Henson

8/22/2022 - Mon