Excel: Multiple VLookup into a list

joshjpang · Jul 22, 2010

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cjoshuap%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CDOCUME%7E1%5Cjoshuap%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CDOCUME%7E1%5Cjoshuap%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style> <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-alt:"Calisto MT"; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-alt:"Times New Roman"; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} span.EmailStyle15 {mso-style-type

ersonal; mso-style-noshow:yes; mso-style-unhide:no; mso-ansi-font-size:11.0pt; mso-bidi-font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; color:windowtext;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} --> </style> [FONT=&quot]Gentlemen, I need your help with Excel: Multiple VLookup into a list<o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]I’m trying to create a list from a larger list. Here’s how it should work:<o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Step 1[/FONT][FONT=&quot]: Get data from a large two-column list.<o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Division[/FONT][FONT=&quot] Product<o

></o

>[/FONT]
[FONT=&quot]1 A<o

></o

>[/FONT]
[FONT=&quot]1 B<o

></o

>[/FONT]
[FONT=&quot]1 C<o

></o

>[/FONT]
[FONT=&quot]1 D<o

></o

>[/FONT]
[FONT=&quot]2 R<o

></o

>[/FONT]
[FONT=&quot]2 S<o

></o

>[/FONT]
[FONT=&quot]2 T<o

></o

>[/FONT]
[FONT=&quot]3 X<o

></o

>[/FONT]
[FONT=&quot]3 Y<o

></o

>[/FONT]
[FONT=&quot]... ...<o

></o

>[/FONT]
[FONT=&quot]1 E<o

></o

>[/FONT]
[FONT=&quot]... ...<o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Step 2[/FONT][FONT=&quot]: Populate this list, doesn’t need to be alphabetical, just no blanks in between.<o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Example: <o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Choose: 1 <o></o>[/FONT]
[FONT=&quot]Result:<o></o>[/FONT]
[FONT=&quot]A <o

></o

>[/FONT]
[FONT=&quot]B <o

></o

>[/FONT]
[FONT=&quot]C <o

></o

>[/FONT]
[FONT=&quot]D <o

></o

>[/FONT]
[FONT=&quot]E<o

></o

>[/FONT]
[FONT=&quot]NULL <o

></o

>[/FONT]
[FONT=&quot]NULL <o

></o

>[/FONT]
[FONT=&quot]NULL <o

></o

>[/FONT]
[FONT=&quot]NULL <o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]So basically, I want to populate a new list with all the Products in that division, one per cell. Is there a way to do this?<o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Your help would greatly be appreciated!<o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]
[FONT=&quot]Thanks a lot guys,<o

></o

>[/FONT]
[FONT=&quot]Josh<o

></o

>[/FONT]
[FONT=&quot]<o

> </o

>[/FONT]

joshjpang · Jul 22, 2010

[FONT=&quot]Gentlemen, I need your help with Excel: Multiple VLookup into a list<o

></o

>
[/FONT] [FONT=&quot]<o

> </o

>
[/FONT] [FONT=&quot]I’m trying to create a list from a larger list. Here’s how it should work:<o

></o

>
[/FONT] [FONT=&quot]<o

> </o

>
[/FONT] [FONT=&quot]Step 1[FONT=&quot]: Get data from a large two-column list.<o

></o

>[/FONT]
[/FONT] [FONT=&quot]<o

> </o

>
[/FONT] [FONT=&quot]Division[FONT=&quot] Product<o

></o

>[/FONT]
[/FONT] [FONT=&quot]1 A<o

></o

>
[/FONT] [FONT=&quot]1 B<o

></o

>
[/FONT] [FONT=&quot]1 C<o

></o

>
[/FONT] [FONT=&quot]1 D<o

></o

>
[/FONT] [FONT=&quot]2 R<o

></o

>
[/FONT] [FONT=&quot]2 S<o

></o

>
[/FONT] [FONT=&quot]2 T<o

></o

>
[/FONT] [FONT=&quot]3 X<o

></o

>
[/FONT] [FONT=&quot]3 Y<o

></o

>
[/FONT] [FONT=&quot]... ...<o

></o

>
[/FONT] [FONT=&quot]1 E<o

></o

>
[/FONT] [FONT=&quot]... ...<o

></o

>
[/FONT] [FONT=&quot]<o

> </o

>
[/FONT] [FONT=&quot]<o

> </o

>
[/FONT] [FONT=&quot]Step 2[FONT=&quot]: Populate this list, doesn’t need to be alphabetical, just no blanks in between.<o

></o

>[/FONT]
[/FONT] [FONT=&quot]<o

> </o

>
[/FONT] [FONT=&quot]Example: <o

></o

>
[/FONT] [FONT=&quot]<o

> </o

>
[/FONT] [FONT=&quot]Choose: 1 <o></o>
[/FONT] [FONT=&quot]Result:<o></o>
[/FONT] [FONT=&quot]A <o

></o

>
[/FONT] [FONT=&quot]B <o

></o

>
[/FONT] [FONT=&quot]C <o

></o

>
[/FONT] [FONT=&quot]D <o

></o

>
[/FONT] [FONT=&quot]E<o

></o

>
[/FONT] [FONT=&quot]NULL <o

></o

>
[/FONT] [FONT=&quot]NULL <o

></o

>
[/FONT] [FONT=&quot]NULL <o

></o

>
[/FONT] [FONT=&quot]NULL <o

></o

>
[/FONT] [FONT=&quot]<o

> </o

>
[/FONT] [FONT=&quot]<o

> </o

>
[/FONT] [FONT=&quot]So basically, I want to populate a new list with all the Products in that division, one per cell. Is there a way to do this?<o

></o

>
[/FONT] [FONT=&quot]<o

> </o

>
[/FONT] [FONT=&quot]Your help would greatly be appreciated!<o

></o

>
[/FONT] [FONT=&quot]<o

> </o

>
[/FONT] [FONT=&quot]Thanks a lot guys,<o

></o

>
[/FONT] [FONT=&quot]Josh<o

></o

>
[/FONT] [FONT=&quot]<o

> </o

>[/FONT]

Special-K99 · Jul 22, 2010

Take a look at Pivot Tables

Excel: Multiple VLookup into a list

joshjpang

New Member

Excel Facts

joshjpang

New Member

Special-K99

Well-known Member

Similar threads

Forum statistics

Share this page

Excel: Multiple VLookup into a list

joshjpang

New Member

Excel Facts

joshjpang

New Member

Special-K99

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock