n the first step both MATCH functions are solved. The first MATCH looks for “certain” (value in D11) in range D3:H3. It finds at 5th location and returns 5. Similarly, the second MATCH looks for the text “Medium” in range C4:C8. It finds it at 3rd position and returns. Finally, the INDEX function looks in the 5th column and 3rd row of array D4:H8 and returns 1500.
So yeah guys, this was a quick example of the Risk Matrix calculation in Excel. I hope it was explanatory enough and served your purpose of being here. If you have any questions regarding this article or anything else about Excel/VBA, let us know in the comments section below.
Lookup nth match using INDEX & MATCH function | To get nth match without using a helper column we use INDEX and MATCH function. We use the boolean logic to get the index from the table.
How to LOOKUP Multiple Values | To retrieve all the matching values from a list, we use the INDEX MATCH function. VLOOKUP can retrieve multiple values only when we use a helper column.Lookup Value with Multiple Criteria | If you have to lookup more than one lookup tables then how do you use VLOOKUP from two Lookup tables or more. This article solves this problem very easily
Lookup Value with Multiple Criteria | We can simply use the VLOOKUP function. But when you don’t have that unique column in your data and need to lookup in multiple columns to match a value, VLOOKUP doesn’t help
How To Look Up Address in Excel | There will be times when you would want to get the address of the cell from which a value is being retrieved. Using that address you can easily retrieve adjacent values using the OFFSET function