Wouldn’t it be great if you could use this autocompleting feature to search for data? Well, you can. I’ll show you how to combine this behavior in Excel in a combo box with a VLOOKUP () function.

Excel macros save you time and headaches by automating repetitive tasks, and you don’t have to be a programmer to write one. Use these tips to make macro recording a cinch.

For example, if you want Excel to find the string "POC135," change the formula to:=VLOOKUP ("POC135", E3:H10, 3, FALSE) Replace unknown characters in the string with question marks, which ...