Why is Excel adding @ to my formula?

[JeffGrant]

Hi All,

I have this formula which is pasted from a VBA module:

=IFERROR(INDEX('All Classes'!$AR$1:$AR$124,MATCH($BV4,INDEX('All Classes'!$B$1:$AQ$124,0,MATCH(1,($BS4=@'All Classes'!$B$1:$AQ$1)*($BT4=@'All Classes'!$B$2:$AQ$2)*($BU4=@'All Classes'!$B$3:$AQ$3),0)),0)),"No Record Found")

You will see there are 3 occurrences of the @ symbol that Excel automatically inserts.

From everything I have read, it shouldn't affect my formula. But it does.

With the @ symbol included, the formula gives the failure result of "No Record Found".

Take the @ symbol out and the Index/Match works the way it is supposed to and returns the values required.

Q1. Why does excel add the @ symbol?
Q2. How can I stop it?
Q3. Do I need to adjust the formula so that it works with the @ symbol?

Thanks

 

[maabadi]

Please upload VBA Code.

 

[ISY]

Hi

In vba ...

.Formula2 =

 

[JeffGrant]

Ah...Thanks Isy