1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Degger [83]
3 years ago
14

In cell Q3, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, the text

"Invalid Staff ID" should be displayed by the formula.
Computers and Technology
1 answer:
stellarik [79]3 years ago
6 0

Normally VLOOKUP is an inbuilt function which is available in MS-excel sheet and used to search the data in vertical column of index.

<u>Explanation:</u>

IFERROR functions returns error means search data type is invalid. In this scenario invalid staff id means either staff id data type is mismatch.

These scenario happens when end user search string data in numeric column of staff id. End user has to correct the staff id data type from string to numeric. Some cases the staff id has invalid data such some special characters are used, such as “-“,”=” etc.

End user has to remove special characters in staff id column and check whether VLOOKUP gives error.

You might be interested in
Help debugging line 7 type error more arguments (5) than expected (1)
kolezko [41]

Answer:

import random

score = 0

for i in range(5):

   num1 = random.randint(1, 100)

   num2 = random.randint(1, 100)

   prompt = "What is " + str(num1) + "+" + str(num2) + "?"

   answer = int(input(prompt))

   result = (num1, num2)

   if answer == result:

       print("Well done!")

       score += 1

   else:

       print("incorrect")

print("Your score was", score)

Explanation:

Your error is on <em>line 7</em>, where you are providing multiple arguments to the input function, instead of 1.

One way to solve this is to create a variable prompt and concatenate all strings and variables within that variable to use for the input.

3 0
1 year ago
Shape: element::paintbrush: ..............
kondor19780726 [428]
There is no question here but it might be paint
6 0
4 years ago
Which scenario best illustrates the information implementation of data governance?
scoray [572]

Answer:       its a

Explanation:

Trust

6 0
3 years ago
(10 points) [Edhesive] 3.6 Code Practice
Digiron [165]

Answer:

  • You need to create a variable outside (before) the input loop.
  • You need a variable inside your loop that temporarily holds the user input.
  • In your loop, you will compare if the variable outside the loop is greater than (or less than) the new user input.

I don't know what program language you are using, but I will use python since it's easy to read and you will get the idea if you're using a different programming language.

<u>Code (Python)</u>

largestnum = 0

for x in range(6): <em>#loops 6 times</em>

   newnum = int(input("Enter a number: ")) #ask user for input & converts to int.

   if newnum > largestnum: <em>#if new number is greater than largest num </em>

     largestnum = newnum     <em>#make it the largest number</em>

<em>    </em>print("Largest:", largestnum)

The reason why you need a variable outside of the loop is because after the loop is done all variables inside the loop are trashed and can no longer be accessed outside of the loop.

3 0
4 years ago
While investing an email issue, a support technician discovers no user can access their email accounts on the company’s email se
Paul [167]

Answer:

The answer is D Check workstations on Lan for APIPA configuration.

Explanation:

1)

While investing an email issue, a support technician discovers no user can access their email accounts on the company’s email server connected to the private LAN.

Pinging the email server form several workstations on the LAN results in 0% packet loss.

Check workstations on Lan for APIPA configuration next step the technician should take in troubleshooting the issue.

7 0
3 years ago
Read 2 more answers
Other questions:
  • How can you best utilize CSS for Web Development?
    6·1 answer
  • Which of the following is CORRECT about database managementsystem's languages?
    6·1 answer
  • What is the problem we can't build shelter on mars ?
    6·1 answer
  • In a typical e-mail address, the "host" is user: which one of the following word processing features saves you the most time whe
    8·1 answer
  • For the purposes of laying out content, the total height of a box is calculated by adding which of the following?
    5·1 answer
  • What is the device that is non-volatile sometime called external memory?<br>​
    15·1 answer
  • After running the following pseudocode, what will the value of VARIABLE be? 1. Set value of VARIABLE to 5 2. Increase the value
    15·1 answer
  • Which of the following terms means the computer operating system automatically detects and installs the proper driver for a new
    9·1 answer
  • which cyber protection condition establishes a protection priority focus on critical and essential functions only
    10·1 answer
  • Ali has created a small program in Python, but he wants to store his data in a multi-dimensional array. He would like to use adv
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!