Applying text data to all duplicates found in another column

[MurdochQuill]

Hello,

I'm trying to apply a set of comments from column F to column B. I'm unable to change the formatting of column A unfortunately. It would be preferable to have a Vlookup function in column B.
Column A will always be variable in length, and column E should always contain the remaining characters after ", " in column A.
Example function I want to use is : =IFERROR(VLOOKUP(INT(MID(A2,SEARCH(", ",A2)+2,LEN(A2)-SEARCH(", ",A2)-2)), E:F,0,FALSE),"Return nill")

I'm just having trouble actually getting this working as it's a little convoluted and has confused me a bit...

Here's the table:

ID	comment			unique id	comment unique id
(5326, 5436) 1				5436) 1	Hello
(5326, 5436) 1				4274) 2	Goodbye
dfdf(3475, 4274) 2				8314) 1	Peace
2 (3475, 4274) 2
1FGFG (7833, 8314) 1
1 (7833, 8314) 1
1 (7833, 8314) 1
FFF 1 (7833, 8314) 1
1 (7833, 8314) 1
1 (7833, 8314) 1

Goals:

ID	comment			unique id	comment unique id
(5326, 5436) 1	Hello			5436) 1	Hello
(5326, 5436) 1	Hello			4274) 2	Goodbye
dfdf(3475, 4274) 2	Goodbye			8314) 1	Peace
2 (3475, 4274) 2	Goodbye
1FGFG (7833, 8314) 1	Peace
1 (7833, 8314) 1	Peace
1 (7833, 8314) 1	Peace
FFF 1 (7833, 8314) 1	Peace
1 (7833, 8314) 1	Peace
1 (7833, 8314) 1	Peace

Any help would be great,
thank you

 

[Peter_SSs]

Welcome to the MrExcel board!

See if this helps.

20 11 21.xlsm
	A	B	C	D	E	F
1	ID	comment			unique id	comment unique id
2	(5326, 5436) 1	Hello			5436) 1	Hello
3	(5326, 5436) 1	Hello			4274) 2	Goodbye
4	dfdf(3475, 4274) 2	Goodbye			8314) 1	Peace
5	2 (3475, 4274) 2	Goodbye
6	1FGFG (7833, 8314) 1	Peace
7	1 (7833, 8314) 1	Peace
8	1 (7833, 8314) 1	Peace
9	FFF 1 (7833, 8314) 1	Peace
10	1 (7833, 8314) 1	Peace
11	1 (7833, 8314) 1	Peace
12		Return nill
Lookup Text

Cell Formulas
Range	Formula
B2:B12	B2	=IFERROR(VLOOKUP(REPLACE(A2,1,FIND(", ",A2)+1,""),E$2:F$4,2,0),"Return nill")