What is Vlookup in Excel?

VLOOKUP: This function returns a value from the intersection between the found lookup value in the leftmost column and a column index number in the Table Array.

To use the Vlookup function, we need common value in both the data and the table, if we do not have a common value in another data from which we want to pick the data, then formula will give the #N/A error.

vlookup with ISNA

Here is the Simple Example ..Please Download Here