Hello Guys,
I’m stuck, can anyone help me figure it out.
Here’s the file I’m working on (can’t upload, because don’t have enough points) - http://goo.gl/hJ2CTa
The last (green) row is the main and all the above are secondary.
I want to create the SKU numbers by Dragging down and filling in the values with C6 content and adding (with CONCATENATE) column O values. So they will be unique.
Example in the file: I have the parent SKU: TPS-FU-AP-IP-001, then there are child items TPS-FU-AP-IP-001-Rojo (red). This table will be copied down to add more products.
So, what I need is, find the closest C parent (as an indicator, the Type column can be used with value Configurable) - then get that value and apend the Color.
I’ve managed to get it for the first line in the file by using this formula:
=CONCATENATE(INDEX(A1:C6,MATCH(A6,A1:A6,0)),"-",O2)
But when I drag down, it adds changes the cells (A6 to A7 etc.).
I can’t lock them by using using $ sings, because when copied below, those should take the values of the new rows (the actual array).
I’m not very good with such formulas, what I was thinking is to search the closest configurable value, once this value is found in the array, get the C* value and lock it in the that array, is it posible?
I’m sorry if I’m not explaining myself clearly, I hope you get the idea.
Thanks and waiting for suggestions,
Best wishes,