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
mina [271]
3 years ago
6

What does the third argument (3) refer to in the following formula: VLOOKUP(10005, A1:C6, 3, FALSE)

Computers and Technology
1 answer:
zzz [600]3 years ago
5 0

Answer:

The answer is "number of the column containing the return value".

Explanation:

In Excel, the "VLOOKUP" method is used to perform the vertical search by looking for both the value during the user table and retrieving the number of the index number location in the same row. It is a built-in function, which is classified as a Lookup or Reference worksheet function, and the following function can be defined as follows:

  • In the 1st parameter, it is used to watch the value for the match.  
  • In the 2nd parameter, it is used to search the table.
  • In the 3rd parameter, it is used as the column number representing the return value.  
  • In the 4th parameter, it is used to return only if the same match is found.
You might be interested in
As part of his proofreading process, and to catch any spelling or grammar mistakes, John uses this feature in Word Online to hav
UkoKoshka [18]
Microsoft word online uses “Proofing Tools”, it can check spelling and grammar, translate the document, and set the proofing language. Word for the web does not use a custom dictionary or include a thesaurus.
5 0
3 years ago
Maggle is preparing a document. She wants to open the help menu to sort out a formatting problem. Which key should she press to
Ann [662]

Answer:

Most probably either F1, F11 or F2 keys assuming that this is a Windows computer

Explanation:

5 0
3 years ago
Which of the following is an unintended consequence of pesticide use on crops?
svp [43]
<span>Which of the following is an unintended consequence of pesticide use on crops?
I know it says computers and technology, but there was no science sign

</span>
3 0
3 years ago
What tasks should a laptop accomplish?
Marta_Voda [28]

Answer:

general & personal used for computing.

3 0
3 years ago
Explain the characteristics of 1st generation computers​
levacccp [35]

Explanation:

i hope this is the right answer

!st generation computers were more big and bulky and you for sure could not bring them around everywhere.

8 0
3 years ago
Other questions:
  • 4. What aspect of the initial database planning process would the formula (0 + Pt × 3 + p)/5 be used in?
    5·1 answer
  • If you want to be more efficient at using the World Wide Web, refresh the page often.
    7·1 answer
  • Emerson needs to tell his browser how to display a web page. Which tool will he use?
    8·2 answers
  • ____ documents consist of the text to be displayed on a Web page, together with a number of special characters: tags that achiev
    14·1 answer
  • A network that typically reaches a few meters, such as up to 10 meters (33 feet), and consists of personal devices such as mobil
    14·1 answer
  • What formatting has been applied to this title?
    8·1 answer
  • Create a file named homework_instructions.txt using VI editor and type in it all the submission instructions from page1 of this
    7·1 answer
  • How do you fix this!!!!
    5·1 answer
  • Which statement best defines the Control Pannel?
    12·1 answer
  • Yaaaaaa.........
    7·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!