Recent Posts

In Excel, to extract score of the student in the subject based on the selection of the dropdowns, you can use data validation and the INDIRECT INDIRECT formula.

In Excel, to build an IF AND statement based on the selection of the dropdown list, combine the IF and AND functions in one formula and use the Data Validation feature.

In Excel, to find the maximum, minimum and average value in the range and return the corresponding value from another range, use the VLOOKUP formula with the AVERAGE, MAX and MIN functions.

In Excel, to find the maximum, minimum and average value in the range and return the corresponding value from another range, use the INDEX MATCH formula with the AVERAGE, MAX and MIN functions.

In Excel, to look up the value in any column of the source data and return the corresponding value from the left column, use the INDEX MATCH formula.