answersLogoWhite

0

VLOOKUP specifies the value it is using to search, the table it is searching and the column within that table to return a value from. Take the following example:

=VLOOKUP(A11,C2:H19,3)

A11 is the cell that contains the value you are searching for. The table it searches in is from C2 to H19. The value will be looked for in the first column of that table, and the 3 indicates that a value from the 3rd column of the table should be returned.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

Which field can not be blank?

Any and all required field(s) cannot be left blank.


When you set up a managing account how do you know which fields are required?

When setting up a managing account, the required fields will typically be indicated by an asterisk (*) or other symbol. These fields must be filled in before the account can be created or the form can be submitted. Additionally, the instructions or terms of service for the account may specify which fields are required. If you are unsure which fields are required, you can check the website's help or FAQ section, or contact customer support for assistance.My recommendation 𝓱𝓽𝓽𝓹𝓼://𝔀𝔀𝔀.𝓭𝓲𝓰𝓲𝓼𝓽𝓸𝓻𝓮24.𝓬𝓸𝓶/𝓻𝓮𝓭𝓲𝓻/250856/𝓑𝓸𝓸𝓼𝓙𝓟/


In order to indicate where a fact or idea came from one must?

One must cite the sources in order to indicate where a fact or idea came from.


How do you apply for nonprofit grants'?

There are forms that must be filled out for nonprofit grants. Sites like nonprofitexpert.com show the steps and forms that must be filled out for nonprofit grants.


Displacement must always indicate?

Displacement must always indicate the change in position or location of an object or particle in a specified direction. It is a vector quantity that measures the distance and direction between an object's starting position and its ending position.


What are the 5 parts of the VLookup function?

VLookup( value, table_array, index_number, not_exact_match )value = value to search for in the first column of the table_arraytable_array = two or more columns of data that is sorted in ascending orderindex_number = column number in table_array from which the matching value must be returned. The first column is 1.not_exact_match = determines if you are looking for an exact match based on value. Enter FALSE to find an exact match. Enter TRUE to find an approximate match, which means that if an exact match if not found, then the VLookup function will look for the next largest value that is less than value.this lesson you can find it on grade 5 computer book...


Where is the academy in grepolis?

You must build the academy yourself in your city. There are requirements that must be filled in order to build it.


What does Jupiter not becoming a star indicate?

there must be a critical mass.:)


State one item of information that must be printed on a bank cheque after it has been filled in and it is input to a computer and why it must be done?

state one item of information that must be printed on a bank cheque after it has been filled in and before it is input to a computer


Do flashing red lights always indicate that you must stop?

Flashing red lights typically indicate that you must stop, but there may be exceptions depending on the specific situation and traffic laws.


Can you write a sentence with the word triplicate in it?

The form must be filled out in triplicate.


Is a square soccer field better then a round soccerr field?

Soccer fields must be rectangles. Square or round fields are not allowed.