Explain the difference between the TRUE and FALSE parameters for the range_lookup argument of a VLOOKUP function. Give a business example of how you would use a VLOOKUP with a PMT function
What will be an ideal response?
In a VLOOKUP placing TRUE in the range_lookup argument allows the function to make an approximate match on a range of values. Placing FALSE in the range_lookup argument allows the function to make an exact match on a range of values. Using the PMT and VLOOKUP functions together is useful as the VLOOKUP function can retrieve an interest range from a range of possibilities while the PMT function calculates a payment based on the retrieved interest rate.
You might also like to view...
When a table is inserted, the TABLE TOOLS contextual tab with the ________ and LAYOUT tabs are displayed
A) FORMAT B) TABLE C) ROWS & COLUMNS D) DESIGN
The author contends that the best way to approach design questions is to
a. ask experts. b. build or prototype something and watch people try to use it. c. let the CEO decide.