JeffGrant
Well-known Member
- Joined
- Apr 7, 2021
- Messages
- 516
- Office Version
- 365
- Platform
- Windows
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
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