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.


What does mandatory fields are in bold mean?

"Mandatory fields are in bold" means that certain fields in a form or document must be filled out for submission or completion. The bold formatting visually distinguishes these required fields from optional ones, indicating their importance. This helps users easily identify which information is necessary to proceed without errors.


What Fields the user must input data in order to process the transaction?

To process the transaction, the user must typically input data in fields such as their name, billing address, payment information (credit card number, expiration date, and CVV), and shipping address if applicable. Additional fields may include email for confirmation and phone number for contact purposes. Ensuring all required fields are accurately filled is essential for successful transaction processing.


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/𝓑𝓸𝓸𝓼𝓙𝓟/


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.


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.


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...


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.


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


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.


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

The form must be filled out in triplicate.


What does Jupiter not becoming a star indicate?

there must be a critical mass.:)