Finds the specified value in the first column of a table or array of values, and returns the value at the specified column in the current row of the table or array.
By default, tables are in ascending order.
grammar
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
■Lookup_value is the value to be looked up in the first column of the data table. Lookup_value can be a number, a reference, or a text string.
When the first parameter of the vlookup function omits the search value, it means that 0 is used to search.
■Table_array is the data table in which you need to find data. Use a reference to a region or region name.
■col_index_num Indicates the number of the data column to search for data in table_array. If col_index_num is 1, return the number of the first column in table_array
Value, col_index_num is 2, returns the value of the second column of table_array, and so on.
If col_index_num is less than 1, VLOOKUP returns the #VALUE! Error value. ; If col_index_num is greater than a column in table_array
The VLOOKUP function returns an error value #REF! .
■Range_lookup is a logical value that indicates whether the function VLOOKUP lookup is an exact match or an approximate match. If FALSE or 0, fine is returned
If no match is found, the #N/A error value is returned. If range_lookup is TRUE or 1, the function VLOOKUP looks for an approximate match,
That is, if no exact match is found, the maximum value less than lookup_value is returned. If range_lookup is omitted, it defaults to 1.
I want to create a clean, concise and efficient office reference manual, in order to maintain a good reference experience, I did not add any third-party advertisements in my blog, of course, if you are willing, you can watch the following video, it can bring me some income, so that I can better maintain the server to provide higher quality service, thank you for your help and support.
You can choose any link below to watch my videos and I will earn some money to strengthen the site and resist DDOS attacks that may happen at any time, thank you for your support!
(Please note: Please do not maliciously click on links or video ads to increase invalid traffic, as this can result in lower or no revenue.)
Learn to consult the manual video
(Will be released in the later period with the consult the manual article, please pay attention.)
My Febspot video list (Learn after-school relaxation videos)
https://suu.us/sponsor
My Febspot video home page
https://www.febspot.com/leet4477/