excel2007 VLOOKUP How to use

Source: Internet
Author: User

1: Save Form B in the Sheet2 of a (the information of a is in Sheet1).

2: The mouse point into the Sheet1 of the first space in the C column is C2.

3: Click FX.

4: Jump out of the dialog box, select VLOOKUP.

5: Click the first input box (where you want to enter the information you want to find), and then click on the first item of the line. Excel automatically takes out the value "John".

6: The last step is to select the information to find, this step is in the second input box in the Sheet2 to find in the range.

Click the second input box directly, and then click Sheet2 to enter the Sheet2 and select the three columns of ABC. Excel automatically takes out these three columns as a lookup range.

7: This step is to tell Excel what value to return if a matching row is found in the Sheet2 by filling in a number in the third input box. Since we gave the lookup range in the previous step, we counted the column to return the value from the first column. Do not exceed the selected lookup range, in this case, enter 3, which returns the value of whether it is completed or not.

8: The last input box is to tell Excel whether to match exactly, 0 is, 1 is no. Some people often reverse this, remember to remember. In this case, the exact lookup, of course, input 0. As pictured above.

9: Click OK, show the following #n/a representative is not found.

10: Double-click the lower-right corner of the item (or copy the item and paste it into the row you want to match), and Excel will automatically complete the remaining lookup for that column. The results are as follows. End

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.