How, and when, to use VLOOKUP
en
All Modules View all topics Close topics
Module 6: VLOOKUP - What It Is and When to Use It

### This Course has been revised!

For a more enjoyable learning experience, we recommend that you study the mobile-friendly republished version of this course.

Take me to revised course.

- or -

Continue studying this course

# How, and when, to use VLOOKUP

• Study Reminders

#### Set your study reminders

We'll email you at these times to remind you to study

You can set up to 7 reminders per week

#### You're all set

We'll email you at these times to remind you to study

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

Sunday

• Study Notes
• Discuss This Topic
 Rafael N. 0 0 In the second scenario, it is ok to use "true" and aproximate the data? At this particular case the discount is fixed to a certain quantity range, for example: 11 or 99 quantity = 3% discount. But if we place "true", wouldn't we aproximate the result in a way that 99 quantity = 6% discount, since 99 is almost 100?
• Text Version