5 thoughts on “How to merge the two files with the electronic meter Excel”

  1. Jaime

    Is the number in the table repeating?
    If there is, it is 1 pair of multi -relationships, which cannot be combined with one line, and it must be merged first. , You can use the VLOOKUP function:
    The number of the numbers in the A-C column A-C
    in the sheet1 blank column, such as d1 input
    = vlookup (A1, Sheet2! A: C, 2 , FALSE)
    The parameters "2" means taking the second column of the sheet2 A-C column, which is B, is B column
    , FALSE)
    and then copy the formula down to bring the various items in sheet2.
    The display "#n/a" is not found in the sheet2.

  2. Jonathon

    I don't understand the production procedure, but I can answer your questions. This is my experience in Excel.

    The use sorting two files at the same time in one worksheet at the same time, and returning the same serial number together, and then merging.

    for reference only.

  3. Miriam

    Because telling ... for a while and a half, I can't tell ... because there are more things on it ... I will teach it for a long time ...

    Effective way ... You spend more than 10 yuan to buy a latest Excel book ... Do it according to the above ...

    and ... When I used to make these forms ... I thought about it ... I try something on the menu bar ... I will definitely try something ... but you have to find a file to copy it first. .. Use this file ...

  4. Damon

    Sort the two forms according to the number, normal and two forms, and then sort the newly generated form according to the number of the old form.
    I has always done this, very convenient and simple.

Leave a Comment