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.