But what if you want to find the last matching value??

The fastest way to find something in a worksheet is to use Excel’s “Find” command.

Go to Edit > Find & Select > Find.  You can also use the keyboard shortcut CTRL+F.  Using either of these and clicking “Find Next” will take you to the next matching cell of your search query.

But what if you want to find the last matching value??

Instead of having to click through each one to get to the end, a simple trick is to select a cell BELOW the range you want to search, then hold down the Shift key while using the “Find” command.

Clicking the “Find Next” button while holding down the Shift key will start at the LAST matching item and search backwards to the top of your worksheet.