Get value and Concattenate

asked 2016-05-27 19:25:49 +0100

shmykis gravatar image

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,

edit retag flag offensive close merge delete