Want to make creations as awesome as this one?

More creations to inspire you

Transcript

FLASHCARDSFORVLOOKUP

Start

REINFORCEMENT SHEET

TOPIC: VLOOKUP

What does VLOOKUP stand for?

Flip card

01

REINFORCEMENT SHEET

TOPIC: VLOOKUP

01

I knew it! Let's move forward

I didn't know... Let's do it again

Let's startthe deck again

VLOOKUP stands for Vertical Lookup.

REVIEW SHEET

TOPIC: VLOOKUP

What are the main arguments of the VLOOKUP function?

Flip card

02

REVIEW SHEET

TOPIC: VLOOKUP

02

I knew it! Let's move forward

I didn't know... Let's do it again

Let's startthe deck again

The main arguments of the VLOOKUP function are lookup_value, table_array, col_index_num, and [range_lookup].

REINFORCEMENT SHEET

TOPIC: VLOOKUP

How do you specify an exact match in the VLOOKUP function?

Flip card

01

REINFORCEMENT SHEET

Lorem ipsum dolor sit amet consecteteur adisciping

01

I knew it! Let's move forward

I didn't know... Let's do it again

Let's startthe deck again

You specify an exact match by setting the [range_lookup] argument to FALSE or 0.

REVIEW SHEET

Lorem ipsum dolor sit amet consecteteur adisciping

What happens if VLOOKUP cannot find a match for the lookup value?

Flip card

02

REVIEW SHEET

Lorem ipsum dolor sit amet consecteteur adisciping

02

I knew it! Let's move forward

I didn't know... Let's do it again

Let's startthe deck again

If VLOOKUP cannot find a match, it returns the #N/A error.

DECK TO REVIEW INA FEW HOURS

BYE, BYE

Review now