I bumped into the following formula in Excel =@INDEX(B100:B110, C100) and was wondering what's the difference with =INDEX(B100:B110, C100) as they both appear to do the same thing. The use-case is to lookup the value of a ComboBox and place it in the cell with such formula.

CodePudding user response：

As mentioned in the comments;

Theory:

The @ is called the Implicit Intersection Operator. See an extensive explaination in the official

Related:

For additional information about practical encounters of the implicit intersection operator:

• Excel VBA - How to add dynamic array formula
• How to distinguish if sumproduct needs to be inserted with CSE or not?