MATCH

Using a scrollbar in Excel In this example we demonstrate the use of a scrollbar to scroll through a list of names. We also use IFERROR(), VLOOKUP(), MATCH(), COUNTIF() and a bit of VBA coding.   Download the workbook here: 

This example is actually about trees. Håkon wants to input one value from a row and one from the heading and get the table value from the cell where the row and column intersect. So, like in the image, if he … Read More