Formula to match two cells to return another cell value.

hi guys - hoping you can help! it would save me a hell of a lot of time!

so this is what I need. its a database I have exported to excel from sage. unfortunately all the fields are messed up! but I have a sheet with them all sorted but minus their account code!

so what I need is a formula that matches the 'address 1' field and returns the account code for that address. so for instance on the attached I need the sheet that says good addresses to pull the matching account code for that contact.

hope that makes! you will save my brain if we can figure a short cut for this!!! Thanks in advance!

Try

=INDEX(Sage!$A$2:$A$10,MATCH('Good addresses'!$B2,Sage!$D$2:$D$10,0))

Thank you sooooo much! u have saved my day!!