Good evening. There is an Excel spreadsheet (for now, 3 columns):

  • in the first column (A) - the list;

  • in the second (B) - the same list, but mixed;

  • in the third column (C) - infa, which must be compared.

In columns B, C is the desired info (on one line). It must be added to the existing list (column A). How to add a bc to a?

Examples
Like now:
ABC
1111 3333 text 3
2222 4444 text 4
3333 1111 text 1
4444 2222 text 2

As we want
ABCD
1111 3333 text 3 text 1
2222 4444 text 4 text 2
3333 1111 text 1 text 3
4444 2222 text 2 text 4

    2 answers 2

    In column D, insert the following formula = RR (A1; B: C; 2; 0) Example:
    ABCD
    1111 3333 text 1 text 3
    2222 4444 text 2 text 4
    3333 1111 text 3 text 1
    4444 2222 text 4 text 2

    • Returns # N / A ... Can not find the value when searching on B: C - Roman Ryzh
    • Strange. This error may occur if Excel, for example, in column A, the value 1111 displays as text, and in column B it displays as a numerical value. It is necessary that the data formats in columns A and B coincide. - Roman
    • In column A, the value is 1111 as text and in B is also text (Made an additional column: concatenated B and C column. Wisely with how to substitute it for A - Roman Ryzh
    • Variant_oshibki_2 : do not believe your eyes. The cell format data can be reduced to the same visual display, but in fact the values ​​may differ. Example: format - Numeric , 0 decimal. Both 2.0 and 2,123 will be displayed as 2 - vikttur
    • @Roman Ryzh, why interlink the values ​​of two columns? It looks like you inaccurately described the task and you misunderstood. - vikttur

    In the D column, enter the formula = INDEX ($ C $ 1: $ C $ 4; MATCH (A1; $ B $ 1: $ B $ 4; 0); 1)
    The range 1--4 can be adjusted by the number of data lines.