Vlookup tutorial in telugu

In This Excel Telugu Video Tutorial you can learn about Vlookup Formula in telugu.MS Excel: VLOOKUP Function (WS)

This Excel tutorial explains how to use the Excel VLOOKUP function with syntax and examples. Notice the importance of the final parameter in returning the correct results.

Description

The VLOOKUP function performs a vertical lookup by searching for a value in the left-most column of the table and returning the value in the same row in the index_number position.

Syntax

The syntax for the Microsoft Excel VLOOKUP function is:

VLOOKUP( value, table, index_number, [not_exact_match] )

Parameters or Arguments

value is the value to search for in the first column of the table.

table is two or more columns of data that is sorted in ascending order.

index_number is the column number in table from which the matching value must be returned. The first column is 1.

not_exact_match is optional. It determines if you are looking for an exact match based on value. Enter FALSE to find an exact match. Enter TRUE to find an approximate match, which means that if an exact match if not found, then the VLOOKUP function will look for the next largest value that is less than value. If this parameter is omitted, the VLOOKUP function returns an approximate match.

Note

• If index_number is less than 1, the VLOOKUP function will return #VALUE!.
• If index_number is greater than the number of columns in table, the VLOOKUP function will return #REF!.
• If you specify FALSE for the not_exact_match parameter and no exact match is found, then the VLOOKUP function will return #N/A.
• See also the HLOOKUP function to perform a horizontal lookup.

Applies To

The VLOOKUP function can be used in the following versions of Microsoft Excel:

• Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000