For example, if you search an inventory sheet for an alphanumeric product code, VLOOKUP can find it even if you don't know the full code. Type the following formula into an Excel cell:=VLOOKUP ...

How to use quick clear in Excel. As is, starting a new search is annoying because you have to clear the search string first. That’s too much work, so let’s add a small piece of code to do it ...

This! Excel is nice and cool, but if you get into the 100k range of things, you're pushing it. Access and Excel can also be made to work together quite well.