XLOOKUP / VLOOKUP

Question 1

XLOOKUP

Answer 1

ONLY if you pay for Microsoft 365

Question 2

Excel doesn’t care if

Answer 2

lower or upper case

Question 3

when you enter the parenthesis (,

Answer 3

excel knows formula & will tell what options

*CURRENTLY IT WANTS BOLD FACE

Question 4

BOLD FACE is what formula wants next

Answer 4

lookup_value

*now just click on cell

Question 5

3 required perimeters do NOT

Answer 5

have brackets around them

Question 6

You gave it the 1st parameter so now the boldface

Answer 6

is on the 2nd parameter (after the comma)

Question 7

lookup_array

Answer 7

that is the range of cells that it’s going to search

Question 8

to search the WHOLE column

Answer 8

click on top of column (E for example)

excel enters:
E:E,

Question 9

return_array

Answer 9

what should it return

Question 10

1 optional parameter is
{if_not_found}

Answer 10

,”Not Found”,

*this means that Excel will type “Not Found” in the cell if the
1st parameter is not in the 2nd parameter

Question 11

After bracketed item AND a comma, Excel gives

Answer 11

options of 0, -1, 1,2

Question 12

VLOOKUP is clunkier

Answer 12

have to enter column 2 instead of 6 because that’s the table array we’ve given it

Question 13

N/A

Answer 13

looks like error message but also saying not a match

Question 14

How must the lookup column appear in the
VLOOKUP table array?

Answer 14

= as the leftmost column in the array

• This is a major restriction for using VLOOKUP.

Question 15

=VLOOKUP(Lucas,B:E,4,False)

Answer 15

This means to look for “Lucas”

Where: Anywhere in columns B:E (ANY row!!!))

*If Lucas is found, then please type the word/# in the 4th SPOT!!!!!!

*If Lucas is not found, please type the word “False”

Question 16

Why would you use
VLOOKUP
with the last input parameter set to
TRUE
?

Answer 16

to require only an approximate match

Correct

Question 17

How can you tell whether a function parameter is optional?

Answer 17

It appears in brackets in the usage template.

Correct

Question 18

Which function should you use with
VLOOKUP
to trap an error?

Answer 18

Correct:

IFERROR accepts two parameters or arguments: the actual function call and the return value upon error.

Question 19

What is the potential problem with specifying columns in a function call such as

Answer 19

The column headers may be included in the ranges.

Correct