Index function help

[JAB]

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.

 

[Ardus Petus]

Assuming your IDs are unique (no dupes)

in A2: =INDEX(Data!A:A,MATCH($B2,Data!$B:$B,0))
Copy into C2 & D2

HTH

 

[JAB]

I used the formula suggested, and I am only able to get the first line of
information (line 2) all the other info says "#N/A". If I didn't make it
clear, I need to be able to call on an ID that may be listed in line 1070 of
the DATA! worksheet, but have it reproduce on line 5 of the new worksheet
(still in column B though).

 

[JAB]

Also, as far as duplicated data, the data sheet that has the ID's already
listed are not duplicated, but the new data needing the added info is usually
duplicated many times.