Index function help
 

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.

Index function help
 

Assuming your IDs are unique (no dupes)

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

HTH
--
AP

"JAB" a écrit dans le message de news:
...
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.

Index function help
 

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).

"Ardus Petus" wrote:

Assuming your IDs are unique (no dupes)

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

HTH
--
AP

"JAB" a écrit dans le message de news:
...
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.

Index function help
 

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.

"JAB" wrote:

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).

"Ardus Petus" wrote:

Assuming your IDs are unique (no dupes)

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

HTH
--
AP

"JAB" a écrit dans le message de news:
...
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.