Hi,
I have a unique use case so please let me explain.
I'm building an xlsx sheet that is used to upload products to eBay via their bulk upload CSV tool.
I have various data validation rules, VLOOKUP and CONCAT formulas set up that are making some of the sheet work.
The area I need help with is mapping manufacturer part numbers to eBay EPIDs.
Ideally, I would love to scrape or access vehicle fitment databases online and connect them to excel but this is outside of my wheelhouse.
As a result of this I find myself manually matching part numbers to eBay EPIDs.
The data in the image below is on a separate sheet called MVL Data.
As you can see there are multiple part numbers that are similar to one single EPID per row.
When I have mapped all part numbers to EPIDs there may be 400+ part number columns.
The below data is on a sheet called Listing Sheet.
When I fill out the listing sheet with item details I would like to have the corresponding EPIDs automatically added to the Product: EPID column when I input a part number that matches against an EPID.
The aim is to remove the manual task of finding all the matching EPIDs amongst the 80,000 row MVL Data sheet and manually adding them to the listing sheet.
The image below shows the end result of this task.
Furthermore, the eBay documentation is rather vague, so I'm not exactly sure if it will accept the Product: EPID column.
I do know it will accept the relationship details columns.
Therefore, instead of adding the EPIDs to a column when adding a part number, I could instead add the Relationship Details column from the MVL Data sheet (viewable in the first image).
See the image below for what this looks like when performed manually.
In summary,
I'm unsure what formulas to use in order to get the data from the MVL sheet into the listing sheet upon inputting a part number.
Does anyone have any ideas or solutions, my Vlookup or Xlookup solutions to this problem seem useless?
I'm a real noob at this stuff so don't know if it's possible via formulas or if VBA is required in order to add the data and add new rows????
All and any help is greatly appreciated...
Thank you in advance,
Alfred
I have a unique use case so please let me explain.
I'm building an xlsx sheet that is used to upload products to eBay via their bulk upload CSV tool.
I have various data validation rules, VLOOKUP and CONCAT formulas set up that are making some of the sheet work.
The area I need help with is mapping manufacturer part numbers to eBay EPIDs.
Ideally, I would love to scrape or access vehicle fitment databases online and connect them to excel but this is outside of my wheelhouse.
As a result of this I find myself manually matching part numbers to eBay EPIDs.
The data in the image below is on a separate sheet called MVL Data.
As you can see there are multiple part numbers that are similar to one single EPID per row.
When I have mapped all part numbers to EPIDs there may be 400+ part number columns.
The below data is on a sheet called Listing Sheet.
When I fill out the listing sheet with item details I would like to have the corresponding EPIDs automatically added to the Product: EPID column when I input a part number that matches against an EPID.
The aim is to remove the manual task of finding all the matching EPIDs amongst the 80,000 row MVL Data sheet and manually adding them to the listing sheet.
The image below shows the end result of this task.
Furthermore, the eBay documentation is rather vague, so I'm not exactly sure if it will accept the Product: EPID column.
I do know it will accept the relationship details columns.
Therefore, instead of adding the EPIDs to a column when adding a part number, I could instead add the Relationship Details column from the MVL Data sheet (viewable in the first image).
See the image below for what this looks like when performed manually.
In summary,
I'm unsure what formulas to use in order to get the data from the MVL sheet into the listing sheet upon inputting a part number.
Does anyone have any ideas or solutions, my Vlookup or Xlookup solutions to this problem seem useless?
I'm a real noob at this stuff so don't know if it's possible via formulas or if VBA is required in order to add the data and add new rows????
All and any help is greatly appreciated...
Thank you in advance,
Alfred
