CODEWITHSUNDEEP
excelduplicates
staff614
staff614

Reputation: 91

Excel, align duplicates + other data

I have 3 columns

A    | B   | C
00046|00046| Description
00046|00056| Description2
00046|00078| Description3
00056|     |
00056|     |
00078|     |

they have to become in column:

A    |  D  |     F
00046|00046| Description
00046|00046| Description
00046|00046| Description
00056|00056| Description2
00056|00056| Description2
00078|00078| Description3

How can i do that? I have this formula, but it works only with one column, not the column description.

=IF(INDEX($L:$L;MATCH($F2;L:$L;0));"")

Upvotes: 0

Views: 30

Answers (1)

Ron Rosenfeld
Ron Rosenfeld

Reputation: 60334

D1: =A1
E1: =VLOOKUP(D1,$B$1:$C$3,2,FALSE)

Select d1:e1 and fill down

enter image description here

Upvotes: 1

Related Questions