Are u ever use vlookup or hlookup formula?
These formulas just can search a cell with a criteria. Then what should we do if we have 2 criterias?
It’s simply u can use this formula
=INDEX(table, MATCH(column criteria, first column of table, 0),MATCH(row criteria, first row of table, 0))
For example, I have a table. First row is subject name and first column is student name. I want to know what is Udin‘s rate in Basic Mathematic subject.
The formula in C11 is: