Use Excel's VLOOKUP Function to Build an Invoice
Loading...
13,732
Loading...
Uploader Comments (DannyRocksExcels)
see all
All Comments (6)
-
you save may day m8, nice work
-
Great tutorial
Very, Very Helpful
-
Nerds rejoice!
-
sir awesome tutorial
good example awesome explanation
Loading...
how to influence if not put the phrase "false" at the end of this formula?
FreeExcelFormulas 7 months ago
@FreeExcelFormulas
In the VLOOKUP Function, the 4th Argument (True or False) is optional - not required.
When you use FALSE - the VLOOKUP will return an "Exact Match" for the value in the leftmost column of the lookup array.
If you leave the 4th argument out, VLOOKUP will use TRUE as the 4th argument. TRUE is the default value and it will look for the "first closest match" it finds in the leftmost column of your lookup array.
Danny Rocks
The Company Rocks
DannyRocksExcels 7 months ago