Excel 3 - C03
0.0(0)
Studied by 0 people
Learn
Practice Test
Spaced Repetition
Match
FlashcardsCard Sorting
1/3
There's no tags or description
Looks like no tags are added yet.
Study Analytics
Name | Mastery | Learn | Test | Matching | Spaced |
|---|
No study sessions yet.
4 Terms
1
New cards
VLOOKUP Function
used to find a match (approx. or exact) and its return corresponding value
2
New cards
Syntax: VLOOKUP Function
= VLOOKUP (lookup value, table range, column number, range lookup)
3
New cards
Range lookup
T = approx match (default and optional)
F = exact match (manually input)
4
New cards
Describe the 2 basic rules for a vlookup table
1st column should be in ascending order
Only 1 value in each cell and has to be min value (approx matches)
Note 
Flashcards (156)