Returns the corresponding position of the element in the array that matches the specified array in the specified manner. If you need to find the position of the matching element rather than the matching element itself,
You should use the MATCH function instead of the LOOKUP function.
grammar
MATCH(lookup_value,lookup_array,match_type)
Lookup_value is the value to look for in the data table.
■ Lookup_value Specifies the value to be searched for in Look_array.
For example, if you want to look up someone’s phone number in the phone book, you should use the name as the lookup value, but what you really need is the phone number.
■ Lookup_value can be a numerical value (numeric, text, or logical value) or a cell reference to a number, text, or logical value.
Lookup_array A range of consecutive cells that may contain the value you are looking for. lookup_array should be an array or an array reference.
Match_type is the number -1, 0, or 1. MATCH-type specifies how the WPS table looks for lookup_value in lookup_array.
■ If Match_type is 1, the MATCH function looks for the maximum value less than or equal to lookup_value.
lookup_array must be sorted in ascending order:… -2, -1, 0, 1, 2,… , A-Z, FALSE, TRUE.
■ If Match_type is 0, the MATCH function looks for the first value equal to lookup_value.
lookup_array can be arranged in any order.
■ If Match_type is -1, the MATCH function looks for the minimum value greater than or equal to lookup_value.
lookup_array must be listed in descending order: TRUE, FALSE, Z-A,… , 2, 1, 0, -1, -2,… Wait a minute.
■ If Match_type is omitted, 1 is assumed.
Instructions
■ The MATCH function returns the position of the target value in lookup_array, not the value itself.
For example, MATCH(b,{a,b,c},0) returns 2, that is, “b” in the corresponding position in the array {a,b,c}.
■ When finding text values, the MATCH function does not discriminate between uppercase and lowercase letters.
■ If MATCH is unsuccessful, it returns the #N/A error value.
■ If MATCH_type is 0 and lookup_value is text, lookup_value can contain wildcards, asterisks (*), and question marks (?). .
Asterisks can match any sequence of characters; A question mark can match a single character.
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/