I have 4 columns, all the rows in the columns go together, example:

Branch: ID: Location: State:
130 ADK Adok Island AK
120 JAN Jackson MS

The columns are 2086 rows long, and are all in this same format.
What I need: Is to be able to (in another worksheet) call upon the "ID" and
it return the Branch, Location, and State... all in the same order as shown
above.
So, to sum up, I want to be able to (in a clean worksheet), copy "ADK" to
cell B2, and it pull up "130", "Adok Island", "AK" in cells A2, C2, and D2,
respectively. Keep in mind that I will be dealing with large volumes of
data, anywhere from 10 to 1500 "ID's" at one time. Any help would be great.