Katie wants to use vlookup for a column in a table. which value of the mode parameter should she use to look for an exact match of the searched data? katie should use the value of mode parameter for an exact match with the searched data.

If you want to lookup for a value in a table given worksheet range, and the column index as well as whether it will be exact match or approximate match, you can do that using the VLOOKUP function. Remember, the data must be arranged in rows in a column. And we can have the exact match or the approximate match. The exact match means one that is a complete match, and approximate match is partial. For the exact match we have range mode =true, and for approximate match we have the range mode = false.

The formula for the condition given in the question can be interpreted as below:

vlookup(value, table_array, column_index,1)

where the value is the data to be searched, table array is the worksheet range like B$6:E$20, and COLUMN INDEX is column number. Remember column index is not case sensitive. And in exact match mode it finds the first match only. This is the limitation of the vlookup,

Explanation:

The answer is self explanatory.