Excel dropdown IF VLOOKUP formula
In Excel, to vertical-lookup with if condition based on the selection of the dropdown list, use an Excel table, data validation and the IF VLOOKUP formula.
Excel dropdown SMALL IF formula
In Excel, to find lowest numeric values with multiple criteria, I will use an Excel table, data validation to create dropdown lists and the SMALL IF formula.
Excel dropdown LARGE IF formula
In Excel, to find highest numeric values with multiple criteria, I will use an Excel table, data validation to create dropdown lists and the LARGE IF formula.
Excel Sort columns of the table
In Excel, to sort columns of the table, I will number the columns and use the Sort feature.
Excel dropdown highlight using check box
In Excel, to highlight the matching row based on the selection of the dropdown list and ticking the check box, I will use an Excel table, data validation, checkbox and conditional formatting.