If Cell Matches Item from Cell Range then Display Item from Different Cell Range

Example: Cell B1 Contains "ABC123" If "ABC123" Matches "ABC123" From a Cell Range/Defined Name "Office Number" Then Output Matching Data From DIFFERENT Cell Range/Define Name "Location City and State.


D1:D5500 Named: "Office Number"
E1:E5500 Names: "Location City and State

Anyone Have an Idea?