MUO on MSN
I’ve been overcomplicating Excel lookups with VLOOKUP — this obscure function changed that
If your VLOOKUP formula needs a helper column, try DGET instead.
Why does VLOOKUP return the wrong value instead of #N/A? The formula is using approximate matching. Add FALSE or 0 as the fourth VLOOKUP argument. If you intentionally use TRUE or omit the fourth ...
The first function in Excel that makes you think, "Hey, maybe I've gotten smarter," is probably VLOOKUP. You enter a product code, and the product name appears. You enter an employee ID, and the ...
Hosted on MSN
6 Functions That Changed How You Use Microsoft Excel
The introduction of dynamic arrays triggered the biggest change to how we work with Microsoft Excel formulas in years, if not decades. They allow a single formula to spill multiple results into ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results