Good afternoon all,
Not sure how well im going to explain this,
I have 2 sheets on this workbook, and im trying to show a "Yes" or "No" value to show if my listing is active on a marketplace. I know i could use a pivot table but I dont want to for certain reasons as this sheet may grow larger over the next few weeks wit hmore data.
On sheet 1, I have my header info with the marketplaces and on sheet 2 I have the SKUs and marketplaces the SKU is listed on.
I would like to place a "yes" or "no" in the cell to match SKU and marketplace if there is a listing or not.
I cant figure out the match formula for this. Any help is greatly appreciated
See attached for the example
Thank you for your time
Bookmarks