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