Data rows with multiple vlookup values

[COGICPENNY]

My problem is in 2 parts.

• Each supplier listed in the tab "IT App Dev" (Column B) needs to be matched with a Commodity Code.
• The Commodity Code is determined by VLOOKUP the SubCategory Code "IT App Dev" (Column K) in the tab "Phase 2 Taxonomy".
• For this SubCategory there are two (2) commodity codes: 80101507 Consulting and 81111509 Application Development Services
• So there would be two (2) rows for each Supplier, the first row would return the value 80101507 Consulting in Column AB, and the commodity description in AC

I created a SAMPLE OUTLOOK FILE tab to see what I'm trying to do: https://1drv.ms/x/s!AsyIxS27y-3Tk2O4u230hbp5IA0w

Unsure if I needed a macro first to create the extra rows then do a lookup using INDEX or something?

Really appreciate the help.

 

[Fluff]

Cross posted http://www.vbaexpress.com/forum/showthread.php?62304-ROW-DUPLICATION-WITH-MULTIPLE-VLOOKUP-VALUES
and https://www.excelforum.com/excel-fo...e-data-row-with-multiple-vlook-up-values.html

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Fluff]

And another one https://www.ozgrid.com/forum/forum/...ata-rows-that-contain-multiple-vlookup-values
@COGICPENNY
Have you posted this question anywhere else? If so kindly provide the links