Hello,
I'm a novice Excel user, but know basic formulas, but this need is stumping me.
Need to find a formula to automate 100's of product image names based on the product SKU. I have a SKU number, imagename.jpg in 2 columns and need to have that list of individual SKUs in a new column with the corresponding images associated with that SKU. Each SKU has a different number of images. The image names have the SKU number in the name. I can Transpose the different SKUs in separate columns but I don't know how to set a formula to go to the next column once there is no more images with that SKU in the name.
I was thinking this could be done with VLOOKUP, INDEX and MATCH and/or IF formulas as combined functions.
IMAGE of what I'm trying to do:
https://www.dropbox.com/s/43lzr9xlpz5w3cd/testing-formulas-v1.JPG?dl=0
Actual Excel Document:
[FONT=wf_segoe-ui_normal]https://www.dropbox.com/s/67jl8c4vzeeh5xx/testing-formulas-v1.xlsx?dl=0
Your expertise would be greatly appreciated!
Jay
[/FONT]
I'm a novice Excel user, but know basic formulas, but this need is stumping me.
Need to find a formula to automate 100's of product image names based on the product SKU. I have a SKU number, imagename.jpg in 2 columns and need to have that list of individual SKUs in a new column with the corresponding images associated with that SKU. Each SKU has a different number of images. The image names have the SKU number in the name. I can Transpose the different SKUs in separate columns but I don't know how to set a formula to go to the next column once there is no more images with that SKU in the name.
I was thinking this could be done with VLOOKUP, INDEX and MATCH and/or IF formulas as combined functions.
IMAGE of what I'm trying to do:
https://www.dropbox.com/s/43lzr9xlpz5w3cd/testing-formulas-v1.JPG?dl=0
Actual Excel Document:
[FONT=wf_segoe-ui_normal]https://www.dropbox.com/s/67jl8c4vzeeh5xx/testing-formulas-v1.xlsx?dl=0
Your expertise would be greatly appreciated!
Jay
[/FONT]