If you need to find the exact position of an asset in your spreadsheet, you can use the MATCH function in Excel. This will keep you from having to figure out where you need to go for directions or the other way around.
The MATCH function is often used with the INDEX function as a top -up view. However, we will go through the process of using MATCH itself to find the location of a property.
What does MATCH do in Excel?
The MATCH function in Excel finds a value in the range, or range of cells, that you specify.
PILI: How to find what you need in Microsoft Excel
For example, you can find the value 10 in the range B2 to B5. Using MATCH as a model, the result is 3 because the value 10 is in the third rank of that model.
The syntax for action MATCH(value, array, match_type)
where the first two opinions are required a match_type
an option.
Competition can be one of three options. If the argument is left out of the original, 1 is used as the default.
- 1: Finds the value below or exactly as searched
value
. The range should increase. - 0: Finds the same value as the one searched
value
and the width can be adjusted. - -1: Finds a small value that is greater than or equal to what is sought
value
. The width should be on the same level.
You may be able to see these comparisons as a tool when you build your model in Excel.
The MATCH process is not difficult, allow asterisk wildcards
and a question mark (?), and return # N / A as error if no match is found.
Use MATCH in Excel
When you are ready to use the MATCH function, take a look at these examples to help you go through building the method. PILI:
Defining and creating a style
=MATCH(10,B2:B5)
MATCH is used to check the status of an asset
=MATCH(10,B2:B5,1)
For example, we will include competition mode 1 at the end of our article. Keep in mind that competition type 1 needs to spread in an ascending manner.
MATCH with match mode 1
=MATCH(10,B2:B5,0)
MATCH with match mode 0
=MATCH(10,B2:B5,-1)
Let’s use the -1 final match method in this case.
REQUIRED with -1 game mode
=MATCH("Caps",A2:A5)
MATCH for finding text in Excel
Now that you know how to use the MATCH function in Excel, you may want to learn about how to use XLOOKUP in Excel or how to use VLOOKUP for asset types.