Hi,
I'm looking for a way to extract info from a table on a different sheet and hopefully put it onto a results sheet:
Info on Sheet ToDo: This contains the info in its original format Info_A_original, plus a Unique_ID
- It won't always appear in the RawInfo. Although it won't have any blanks, the number of rows will vary
Info on Sheet RawInfo: This contains the info which has already been "translated": Info_version_B & its translated version: Info_version_C_translated
- It won't always appear in sheet ToDo. Although it won't have any blanks, the number of rows will vary
- "Info_version_B's can have mutiple different translations ("Info_version_C_translated") & and vice versa
Info on Results Tab (hopefully!):
i) will take each entry from ToDo [Info_A_original]
ii) check it against the RawInfo [Info_version_B]
iii) and if the Info_A_original is contained in Info_version_B, then list the findings (= Info_version_C_translated & its corresponding Info_version_B)
iv) and have a separate line on the results sheet for each corresponding result
(hopefully this would not be case-sensitive!)
I've seen something similar posted here How to extract multiple values from same lookup
Am new to using the (excellent!) xl2bb, hope it worked ok
Many thanks
PS am using office365
I'm looking for a way to extract info from a table on a different sheet and hopefully put it onto a results sheet:
mr_excel_data_extract_post.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | Unique_ID | Info_A_original | ||
2 | 2 | Baum | ||
3 | 3 | Conduct | ||
4 | 4 | CONDUCTEURS ELECTRI | ||
5 | 5 | Faisceau | ||
6 | 6 | FAISCEAU DE CONDUCT | ||
7 | 7 | KABEL | ||
8 | 8 | KABELBAUM | ||
9 | 10 | KABELBAUM, VERZWEIG | ||
10 | 11 | xxxKabelbaumxxx | ||
11 | 12 | Wiring Harness | ||
ToDo |
mr_excel_data_extract_post.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | Info_version_B | Info_version_C_translated | ||
2 | Assemblee Absorptive | Absorber Assembly | ||
3 | BAUM | Harness | ||
4 | CONDUCTEURS ELECTRI | Lead Set,Electrical | ||
5 | FAISCEAU DE CONDUCT | Wiring Harness | ||
6 | KABELBAUM | Wiring Harness | ||
7 | KABELBAUM, VERZWEIG | Wiring Harness,Branched | ||
8 | Wiring Harness | FAISCEAU DE CONDUCT | ||
9 | Wiring Harness | KABELBAUM | ||
RawInfo |
mr_excel_data_extract_post.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Unique_ID | Info_A_original | Info_version_B | Info_version_C_translated | ||
2 | 2 | Baum | KABELBAUM | Wiring Harness | ||
3 | KABELBAUM | Wiring Harness,Branched | ||||
4 | KABELBAUM, VERZWEIG | Wiring Harness,Branched | ||||
5 | 3 | Conduct | CONDUCTEURS ELECTRI | Lead Set,Electrical | ||
6 | FAISCEAU DE CONDUCT | Wiring Harness | ||||
7 | 4 | CONDUCTEURS ELECTRI | CONDUCTEURS ELECTRI | Lead Set,Electrical | ||
8 | 5 | Faisceau | FAISCEAU DE CONDUCT | Wiring Harness | ||
9 | 6 | FAISCEAU DE CONDUCT | FAISCEAU DE CONDUCT | Wiring Harness | ||
10 | 7 | KABEL | KABELBAUM | Wiring Harness | ||
11 | KABELBAUM | Wiring Harness,Branched | ||||
12 | KABELBAUM, VERZWEIG | Wiring Harness,Branched | ||||
13 | 8 | KABELBAUM | KABELBAUM | Wiring Harness | ||
14 | KABELBAUM | Wiring Harness,Branched | ||||
15 | KABELBAUM, VERZWEIG | Wiring Harness,Branched | ||||
16 | 9 | KABELBAUM, VERZWEIG | KABELBAUM, VERZWEIG | Wiring Harness,Branched | ||
17 | 12 | Wiring Harness | Wiring Harness | FAISCEAU DE CONDUCT | ||
18 | Wiring Harness | KABELBAUM | ||||
Result |
Info on Sheet ToDo: This contains the info in its original format Info_A_original, plus a Unique_ID
- It won't always appear in the RawInfo. Although it won't have any blanks, the number of rows will vary
Info on Sheet RawInfo: This contains the info which has already been "translated": Info_version_B & its translated version: Info_version_C_translated
- It won't always appear in sheet ToDo. Although it won't have any blanks, the number of rows will vary
- "Info_version_B's can have mutiple different translations ("Info_version_C_translated") & and vice versa
Info on Results Tab (hopefully!):
i) will take each entry from ToDo [Info_A_original]
ii) check it against the RawInfo [Info_version_B]
iii) and if the Info_A_original is contained in Info_version_B, then list the findings (= Info_version_C_translated & its corresponding Info_version_B)
iv) and have a separate line on the results sheet for each corresponding result
(hopefully this would not be case-sensitive!)
I've seen something similar posted here How to extract multiple values from same lookup
Am new to using the (excellent!) xl2bb, hope it worked ok
Many thanks
PS am using office365