Complicated Index Match Formula
Hopefully someone can help me out with the below scenario:
I need to pull Company Name from another sheet that matches the Name (ie AAA). Then I need to pull the ranking which is a different column in the same sheet that matches both Name and Company Name.
Help Article Resources
Check out the Formula Handbook template!