Header Ads

What is Vlookup in Excel?

September 30, 2015
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

Post a Comment

No comments

Subscribe to: Post Comments ( Atom )