Excel Macro Developer

Need a way that PDF's once converted to excel sheets are able to align an apartment unit to it's matching rent amount. Our issue is that sometimes the rows do not align so need some macro or formula created that searches for the correlating amount for each unit.