For many, the INDEX-XMATCH combination in Excel is the go-to method for retrieving a value from a dataset. However, you can ...

Instead of typing direct cell references (such as B2) into your formula, if you click cell B2, Excel will insert the column name into the formula to create a structured reference.