VLOOKUP and Filtering Flashcards
1
Q
What is the purpose of
VLOOKUP?
A
The primary purpose of the VLOOKUP function is to search for a specific value in a column of data and return a corresponding value from another column.
2
Q
What is the Syntax for Vlookup?
A
=pmt(rate,nper,pv,{fv},type)
3
Q
What is Filtering?
A
Filtering is the process of selecting some of the records of a worksheet on the basis of certain criteria.