Forum Discussion
Match Cells on Sheet 1 & 2 and return value from multiple cell on Sheet 2 to one cell on Sheet 1
Sheet 1, Column A list names. Sheet 2 Column A lists names. Some names are listed multiple times but with different values in Sheet 2 Column B. If the name in Sheet 1, Column A matches the name/n...
=IFERROR(INDEX($B$1:$B$12,SMALL(IF($E1=$A$1:$A$12,ROW($1:$12)),COLUMN(A1))),"")
Maybe with this formula as in the attached file. Enter formula with ctrl+shift+enter if you don't work with Office365 or 2021. Formula in cell J1 in the attached example is: =CONCATENATE(F1,G1,H1,I1)