Vlookup Function In Excel. The vlookup function is one of the most useful functions in excel, and is a fast way to look up a value when your information is arranged in rows and columns. The vlookup function has four arguments (values in the function separated by commas) and because of this people often think vlookup is complex.

Equal to the specified value). The formulas using these two functions can easily search for any specific values from any given dataset. If the fruit is not present, cell c11 will give “not present” as you can see for “watermelon.”.