Excel function (chapter vlookup)

There is VLOOKUP function of the function that retrieves the character string in Excel.
The vlookup function is a function of discovering the line to which the specified item is input, and retrieving the value input to the row from among the specified table.
【 format 】
“= vlookup (character string for retrieval, cell for retrieval, extraction row, and search strategy)”
【 explanation of parameter 】
The character string for the retrieval: The retrieval character string is input.
The cell for the retrieval: It is input (possible the range selection) extraction row as for the cell that retrieves it: It is specified retrieval method as for the row to want to display after it retrieves it: → when retrieving it for →”FALSE” when usually retrieving it and two minutes. ｢TRUE｣
【 usage example 】
=Vlookup (“Retrieve it” $A$1:$D$99, 4, and FALSE).
【 explanation of usage example 】
It is retrieved whether there is a character “Retrieve it” in A1?D99 of the cell, and displays the value of the fourth row (D row) from the left.
【 notes 】
Please specify for the leftmost side within the range to be retrieved to become the object row of the retrieval. Moreover, please contain the extraction row to display in the cell for the retrieval after it retrieves it and specify it.
For instance, when character string that exists in [desuga] and A row is retrieved, and value that exists in G row is displayed, A?Please specify G row.
When the order of the row in the table doesn’t become it so, it is necessary to permute the retrieval row like specifying the extraction row for the cell for the retrieval on the leftmost side.
Moreover, please sort the search strategy and sort the object table of the retrieval beforehand when you specify the retrieval for two minutes of “TRUE”.