COGICPENNY
03-20-2018, 06:33 AM
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.
Unsure if I needed a macro first to create the extra rows then do a lookup using INDEX or something?
Really appreciate the help.
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.
Unsure if I needed a macro first to create the extra rows then do a lookup using INDEX or something?
Really appreciate the help.