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. How to Copy Columns in Excel Using VBA. Many small ...