| Join MS Excel Course | Click Here |
VLOOKUP stands for Vertical Lookup. VLOOKUP is a tool in Excel that lets you search for a particular value by looking up and down in a table. It’s like finding information in a list or spreadsheet by moving vertically instead of horizontally. Video is given below.
VLOOKUP Formula
=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
VLOOKUP Formula Video
Example: How to use
=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
- Search for ‘Fontana’ and show ‘First name’.
- Fontana is in Cell B3.
- We will search from cell B2 till E7.
- First name is in 2nd column.
- False means exact match. True means approximate match.
- so formula will be = VLOOKUP(B3, B2:E7, 2, FALSE)
Another example
- Find’102′ and show ‘last name’
- so formula will be = VLOOKUP(A3, A2:C7, 2, FALSE)
