I have a sheet with over 2500 skus that need to be updated. I have the updated sheet already with pricing.
What I want is for it to search New pricing for Sku and put the default price to the correct price
I tried vlookup but couldn’t get it to search an array for the sku… just worked by row number
Index might be what I need but I cant get that to work… limited ability in excel folks.. Thank you
See attached.
Bookmarks