if I used hlookup I would manually need to change the lookup term which for 9000 companies would be pointless I think
I think what I need should be simple but explaining it correct is hard.
would a fancy if formula work? so say IF excel finds this index in this row of index then 1 else 0 then just sort high to low so all the number 1's are at the start?