Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 index function does not calculate | Excel Worksheet Functions | |||
Index function works in A2, but not in A10, Why is that? Cant figure it out. | Excel Worksheet Functions | |||
If function using Index | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |