Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
Ana Maria 25 pe Simpatie.ro
 | Femeie
24 ani
Bucuresti
cauta Barbat
35 - 68 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 960
|
|
Note: For this you need to install the free function add-on for Excel called MOREFUNC: http://mrrrr.3xforum.ro/post/1628/1/Exc ... Functions/
So I need to look for a string in 2 different columns and concatenate everything I find for that string from 2 other columns.
I have MATERIAL in A:A, and STRING to look for in E:E
I have GROUP in I:I, and STRING to look for in M:M
STRING is the same, only I have to look in 2 different columns for return values (MATERIAL & GROUP). It could as well have been 2 different sheets of data, but I put my tables in the same sheet to reduce the length of the formula.
Here it goes (ARRAY formula, enter with CTRL+SHIFT+ENTER):
="Group: "&SUBSTITUTE(MCONCAT(IF(M:M=A2;"; "&I:I;""));";";"";1)&" // Material: "&SUBSTITUTE(MCONCAT(IF(E:E=A2;"; "&A:A;""));";";"";1)
This concatenates in 1 cell whatever values in columns I:I (GROUP) and A:A (MATERIAL) on the row that matches the value in A2 in columns M:M and E:E.
Source:
https://www.mrexcel.com/forum/excel-que ... tches.html
|
|
| |
|
