V Look Up Exact

What we need to select for searching solution from a particular range. Either the entire cell range or the columns only. In the tutorial example only columns were selected.
Please clarify.

please share the example or screen shot or cell references