Extract multiple entries based on the info from a different sheet

ellison

Board Regular
Joined
Aug 1, 2012
Messages
200
Office Version
  1. 365
Platform
  1. Windows
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:

mr_excel_data_extract_post.xlsx
AB
1Unique_IDInfo_A_original
22Baum
33Conduct
44CONDUCTEURS ELECTRI
55Faisceau
66FAISCEAU DE CONDUCT
77KABEL
88KABELBAUM
910KABELBAUM, VERZWEIG
1011xxxKabelbaumxxx
1112Wiring Harness
ToDo


mr_excel_data_extract_post.xlsx
AB
1Info_version_BInfo_version_C_translated
2Assemblee AbsorptiveAbsorber Assembly
3BAUMHarness
4CONDUCTEURS ELECTRILead Set,Electrical
5FAISCEAU DE CONDUCTWiring Harness
6KABELBAUMWiring Harness
7KABELBAUM, VERZWEIGWiring Harness,Branched
8Wiring HarnessFAISCEAU DE CONDUCT
9Wiring HarnessKABELBAUM
RawInfo


mr_excel_data_extract_post.xlsx
ABCD
1Unique_IDInfo_A_originalInfo_version_BInfo_version_C_translated
22BaumKABELBAUMWiring Harness
3KABELBAUMWiring Harness,Branched
4KABELBAUM, VERZWEIGWiring Harness,Branched
53ConductCONDUCTEURS ELECTRILead Set,Electrical
6FAISCEAU DE CONDUCTWiring Harness
74CONDUCTEURS ELECTRICONDUCTEURS ELECTRILead Set,Electrical
85FaisceauFAISCEAU DE CONDUCTWiring Harness
96FAISCEAU DE CONDUCTFAISCEAU DE CONDUCTWiring Harness
107KABELKABELBAUMWiring Harness
11KABELBAUMWiring Harness,Branched
12KABELBAUM, VERZWEIGWiring Harness,Branched
138KABELBAUMKABELBAUMWiring Harness
14KABELBAUMWiring Harness,Branched
15KABELBAUM, VERZWEIGWiring Harness,Branched
169KABELBAUM, VERZWEIGKABELBAUM, VERZWEIGWiring Harness,Branched
1712Wiring HarnessWiring HarnessFAISCEAU DE CONDUCT
18Wiring HarnessKABELBAUM
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
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,129,511
Messages
5,636,759
Members
416,938
Latest member
sc58963

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top