Hidden Tricks in Excel Functions and User Interface - 2:

Tricks for Selecting a Range Using the GOTO Feature: 

Imagine your active cell is D3 and you want to select the range from A1 to D3.

Method-1:

Press CTRL + G to open the GOTO dialog box, enter A1 in the reference box, then instead of pressing ENTER, hold the SHIFT key and press ENTER.

Method-2:

You can enter formulas like INDEX, CHOOSE, or INDIRECT in the reference box, which return a reference. Then, hold the SHIFT key and press ENTER.

=CHOOSE(1,A1,B1,D1)

The formula above returns A1 as a reference, so the range from A1 to D3 is selected. 

You can also use the name box:

Press Alt + F3 to enter edit mode in the name box, type A1, then press SHIFT and ENTER. 

All these techniques allow you to select the range from the active cell to the specified reference.

Comments within Excel Formulas: 

Excel does not offer a built-in way to insert comments directly inside formulas.

However, you can use a workaround by utilizing the N or T functions.

Here’s a straightforward example using XLOOKUP.

For numeric results:

=XLOOKUP(E4,A3:A7,C3:C7)+

N("lookup product and extract price") 

For text results:

=XLOOKUP(E8,A3:A7,B3:B7)&

T(N("lookup product and extract supplier"))

Suggested by Mahmoud Bani Asadi,

=LET(

c,"lookup product and extract supplier",

XLOOKUP(E8,A3:A7,B3:B7))

Suggested by Rick Rothstein,

For text results:

=XLOOKUP(E8,A3:A7,B3:B7)&

T(N("lookup product and extract supplier"))

&TEXT("This is a comment",";;;")

For numeric results:

=XLOOKUP(E4,A3:A7,C3:C7)+

N("lookup product and extract price")

+TEXT("This is a comment",";;;\0")