2016-05-27 19:25:49 +0100 asked a question Get value and Concattenate 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, 2016-05-27 18:54:14 +0100 received badge ● Famous Question (source) 2015-08-24 09:34:01 +0100 received badge ● Notable Question (source) 2015-07-23 14:52:49 +0100 received badge ● Popular Question (source) 2015-07-22 19:13:01 +0100 received badge ● Editor (source) 2015-07-22 19:11:04 +0100 asked a question Extract/Filter cell text from pattern. Hey Guys, First of all, I want to appologize for my English. :) I would like to get your suggestions on how to filter the values I need and remove the rest from the cell in another cell. To make this more clear here are few examples: I have this line in Cell F1: 4 CARTUCHOS COMPATIBLE NON OEM EPSON T1285 T1281 T1282 T1283 T1284 NO ORIGINAL and I need to get in Cell H1: T1285 T1281 T1282 T1283 T1284 (from the line above). Basically what I need is to extract/filter (I hope I'm using the correct term) pattern: TXXXX from all the cells in the F columns. Thank you for the help, Cheers,