Excel Help

I need help with a formula in Excel. Currently, I am comparing two lists (2022 Fortune 1000 and 2018 Fortune 1000). I need to know the change in rank of the companies between 2018 to 2022. This seems simple, but I cannot figure it out.