Excluding the Initial Cell from a Range in a Formula

[newexceluser1]

Hello,

I am currently looking for a way to exclude a referenced Cell from an Excel formula but I'm fairly new to Excel. The function I am currently using is used to generate a referenced Cell based on "duplicated" information in the Cell (IE. If A1 has "Text", and A4 has "Text", C3 will generate "A4" as text) within the range. Here's a summary of what I'm trying to do as well as where the issue lies:

Expected
Cell A2 has "Test" text inputted
Cell A4 has "Test" text inputted
Cell C2 searches through range A2:A300 for any cells that contain the same text and then spits out the referenced Cell as text (NOT the contents of the referenced cell)
Cell C2 generates "$A$4", desired result
Cell C4 generates "$A$4", not desired result (should be $A$2)

Here is the function being used: =CELL("address",INDEX($A$2:$A$300,MATCH(A2,$A$2:$A$300,1)))

The byproduct of using this function is that the referenced Cell that is generated always seems to be the last "duplicate" within the range, but this is fine.

Example
A2 = Test
C2 = A$2$

A2 = Test
A4 = Test
C2 = A$4$

A2 = Test
A4 = Test
A8 = Test
C2 = A$8$

Is the function/formula I am looking for possible? Any help or guidance would be greatly appreciated.

 

[Aladin Akyurek]

Is the input either Test or nothing at all?

 

[newexceluser1]

Is the input either Test or nothing at all?

It will vary- for context, the input is a list that will be contributed to (IE. specific text) and I want to ensure that there are no instances of the same text and that if there is, the adjacent 'C' Cell will generate the Cell that contains an instance of the inputted text.

Example
A1 - Test1
A2 - Test2
A3 - Test3
A4 - Test4
etc.

 

[Aladin Akyurek]

Book1
	A	B	C
2	Test		$A$3, $A$5
3	Test		$A$2, $A$5
4	WAD		$A$6
5	Test		$A$2, $A$3
6	WAD		$A$4
Sheet1

In C2 control+shif+enter, not just enter, and copy down:

=IF(MAX(FREQUENCY(IF($A$2:$A$6<>"",IF($A$2:$A$6=$A2,MATCH($A$2:$A$6,$A$2:$A$6,0))),ROW($A$2:$A$6)-ROW($A$2)+1))>1,TEXTJOIN(", ",TRUE,SUBSTITUTE(ADDRESS(IF($A$2:$A$6=$A2,ROW($A$2:$A$6),ROW($A2)),COLUMN($A$2)),CELL("address",$A2),"")),"")

Note. A solution using VBA would be preferable.