This article shows how to use vlookup with if condition in Excel. Go through the 6 examples and practice by yourself.