Excel Magic Trick 1254


Lookup Item Where 2 Values Are Closest: Helper Column or Array Formula?
Learn how to create solution to lookup an item where two values are closets in value:
(00:10) Problem Introduction
(00:36) Helper Column Solution and two cell formulas using ABS, MIN and INDEX & MATCH functions.
(03:15) Single Cell Formula using ABS, MIN and INDEX & MATCH functions, and two array operations. Learn about what an array operation and array formula is, and learn how to enter an array formula into a cell using Ctrl + Shift + Enter.
(08:13) Look at list of functions that can handle array operations without any special keystrokes.