Constantly changing list of data in excel with a data validation list -

i have piece of coding order list of people in order highest lowest performance (in percent). means if person performs , person value goes up, go list of people, coding follows:

=iferror(index('[filename.xlsx]sheet'!$a$4:$a$1000,match(large('[filename.xlsx]sheet'!$as$4:$as$1000,row()-4),'[filename.xlsx]sheet'!$as$4:$as$1000,0)),"") 

dragged down

the coding above works piece of coding ranks data higher data, higher number be:

{=if(ar4="","",sum(1*(ar4>$ar$4:$ar$1000))+1+if(row(ar4)-row($ar$4)=0,0,sum(1*(ar4=offset($ar$4,0,0,index(row(ar4)-row($ar$4)+1,1)-1,1)))))} 

dragged down

so code above pulls through employees unique id dependent on performance percentage.

with unique id, have used vlookups rest of data come through it, including name, country, sector etc...so if person performance goes up, move list , correct data kept on same line.

now problem having want assign manually these people job role using data validation list in new column problem begins.

so have added column each cell contains data validation list when give person job role...and moves list, rest of data moves down but, job role/data validation stays in same cell , not move down data. wondering if there way counter , make when job role attached employee move employee.

an example of above:

unique id    name    country    performance  job role     123456789    tom     uk         90%          boss 987868564    bill    usa        76%          salesman 162537456    steve   sweden     52%          worker 

now, in case steve gets 99% performance:

unique id    name    country    performance  job role (list)    162537456    steve   sweden     99%          boss 123456789    tom     uk         90%          salesman 987868564    bill    usa        76%          worker 

notice job roles stay in same place? - tom should have boss job role, bill should salesman , steve should worker.