$7)$ Use IFERROR to display a message if VLOOKUP doesn$$t find your entry.

To do this we will use a logical function and a lookup function together. When I am using logical functions with other functions, I like to build

outward. This means I am working somewhat backwards, but it helps me troubleshoot errors if they come up$.$

$$ Click cell G$9.$

$$ Go to the formulas tab and click Insert Function. Select VLOOKUP.

$$ Type $$Joshua$$ for your lookup$\_$value

$$ Select the entire data table $($A$4$:D$17)$ for your table$\_$array.

$$ Type $2,$ which corresponds to No$.$ Customers, for your col$\_$index$\_$num.

$$ Type FALSE, which gives an exact match, for your range$\_$lookup.

$$ Click OK

$$ Your cell should now have #N$/$A$.$

$$ Now click cell G$9$ again.

$$ First place a parenthesis to the left of the VLOOKUP.

$$ Now add IFERROR between the equal sign and the parenthesis left of the VLOOKUP.

$$ Now add a comma to the right of the far$-$right parenthesis.

$$ Now add $$Not Found :$-(($or some other humorous message$).$

$$ Close the function by adding a parenthesis to the right of your message and hit enter.

$$ Your cell should now have Not Found :$-(,$ or whatever humorous message you chose. The IFERROR function can be nice because it

gives a better visual indicator of why your function did not work, and can be helpful when you are using logical$/$lookup functions on

large datasets.

Question $7$: How many customers did Joshua have? Without an Error message showing.

Not Found :-(