Flowchart: Which Excel LOOKUP Function Should I Use?
When you want to look up data in Excel, you can choose from various functions: LOOKUP (in two forms), VLOOKUP, HLOOKUP, and the combination of INDEX(MATCH). Which should you use? Here’s a flowchart to help guide you: The first and most important question is, “do you want an exact match or an approximate match?” If…