Easy excel question

I am downloading college basketball rpi rankings that change nightly. I am assigning the ranking of each school to a cell on an earlier page. Example: If the current RPI of Duke appears in E9 and i assign it to that earlier cell by =E9, then I’m all messed up when I refresh the next day and Duke’s RPI now appears on E12. Whatever appears in E9 will populate the earlier cell. How do I tell the earlier cell to capture the number that appears next to Duke’s name after I refresh and Duke moves?

Would it be  =$E$9

 

THanks so much!

Mitch

By: Mitchell Levy

Leave a Reply

Your email address will not be published. Required fields are marked *