Provide examples of when you would use the TRUE/FALSE options for the fourth argument in a VLOOKUP
What will be an ideal response?
If an exact value is not needed in the return value when examining the data ranges, the TRUE argument should be used. This is the default value when the argument is omitted. This would be used for converting exam scores to a letter grade. If the data is looking for an exact match, the FALSE argument should be used. This would be used to lookup a student's ID number and return their e-mail address.
You might also like to view...
A web browser's ________ feature makes it easy to return to a specific web page
Fill in the blank(s) with correct word
Clicking the Show Formulas button in the Formula Auditing group on the Formula tab displays the ________ in the appropriate cells
A) underlying formulas B) displayed values C) displayed formulas D) underlying values