Wednesday, 1 July 2015

VLOOKUP IN EXCEL



SYNTAX : VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]
                  Ex:-

             1 A B C D
2 Student Telugu English Maths
3 Abhi 58 76 85
4 Rahul 56 85 89
5 Gautam 86 75 99
6 Raju 82 89 87

   
 VLOOKUP means Vertical Lookup. Here we use this formula to find out howmany marks got Abhi in English subject.
so here  lookup_value is Abhi.
              table_array is A2:D6.
              col_index_num is 3.
              range_lookup is FALSE(Exact match).
When we enter these in formula then get  76.      
See the following video how to use VLOOKUP formula in EXCEL.
Reactions:

TRT UPDATES

View More

CCE UPDATES

TSPSC UPDATES

ADVERTISEMENT