Now that the document creation series has come to a pause, this time I'll be talking about Excel. For accounting professionals, Excel might be the tool we use the longest, yet it's also the one that ...
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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results