I was finishing my task for water resource management course when suddenly i remember that i need to write about “VLOOKUP” and “INDEX MATCH”. Why? simply because i often forget about INDEX MATCH formula. While the VLOOKUP is the additional because i think it’s easier to understand INDEX MATCH after taste what VLOOKUP is.
VLOOKUP stands for Vertical Look Up. To make it easier, let’s say we have a list of information in a table. Let’s say… inflow table… see this..
Let’s say we have the data in that yellow table and then we have the orange table. We want to know, how much the inflow in October, May, and January are. So we can type that formula…. btw…. Oooopsss… i’ve written about this in my previous post. Check this out.. ^^V
Now, let’s move to the “INDEX MATCH”. Principally, it works like VLOOKUP. When VLOOKUP read the data to the right column, INDEX MATCH works vice versa. It looks in the right column, and work to the left.
Let’s see another table…
So, the previous table (from column “Y” to column “AD”) as the data. Cell “AE8” bellow the f4(S4) column is the maximum value of the previous column. We’d like to know how much is the “X4” (column Z) when column AD is equal to its maximum value (see the green highlight). *I use a conditional formatting for that green highlight, by the way…
Ah, let’s get this even much easier by trying those formulas on this excel file i provide for you : Example