Duplicate rows for vlookup multiple values

[Victor Moss]

Hey guys,

I'm importing a sheet and doing a vlookup to assign values as vlookup works, however, if the vlookup is finding values to assign, I need to duplicate the row to which the value must be assigned to as many times as what there are rows for those values. Would anyone know how to do this?

Thanking you in advance...

 

[Panda514]

Hello, can you provide an example of what this would look like? A vlookup is used to find extra information about say and employee id in another file/sheet that also contains the employee id. I'm not sure what you mean by "duplicating the row to which the value must be assigned to as many times as what there are rows for those values."

 

[Victor Moss]

<tbody>
[TD="class: xl67, colspan: 7"]Original Scenario[/TD]

[TD="class: xl65"]a[/TD]
[TD="class: xl65"][/TD]

[TD="class: xl65"]b[/TD]
[TD="class: xl65, align: right"]1[/TD]

[TD="class: xl65"]b[/TD]
[TD="class: xl65"][/TD]

[TD="class: xl65"]a[/TD]
[TD="class: xl65, align: right"]2[/TD]

[TD="class: xl65"]c[/TD]
[TD="class: xl65"][/TD]

[TD="class: xl65"]d[/TD]
[TD="class: xl65, align: right"]3[/TD]

[TD="class: xl65"]d[/TD]
[TD="class: xl65"][/TD]

[TD="class: xl65"]c[/TD]
[TD="class: xl65, align: right"]4[/TD]

[TD="class: xl65"]e[/TD]
[TD="class: xl66"][/TD]

[TD="class: xl65"]f[/TD]
[TD="class: xl65, align: right"]5[/TD]

[TD="class: xl65"]f[/TD]
[TD="class: xl65"][/TD]

[TD="class: xl65"]e[/TD]
[TD="class: xl66, align: right"]6[/TD]

[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl65"]e[/TD]
[TD="class: xl66, align: right"]7[/TD]

[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl65"]e[/TD]
[TD="class: xl66, align: right"]8[/TD]

[TD="class: xl67, colspan: 7"]Solved Scenario[/TD]

[TD="class: xl65"]a[/TD]
[TD="class: xl65, align: right"]2[/TD]

[TD="class: xl65"]b[/TD]
[TD="class: xl65, align: right"]1[/TD]

[TD="class: xl65"]b[/TD]
[TD="class: xl65, align: right"]1[/TD]

[TD="class: xl65"]a[/TD]
[TD="class: xl65, align: right"]2[/TD]

[TD="class: xl65"]c[/TD]
[TD="class: xl65, align: right"]4[/TD]

[TD="class: xl65"]d[/TD]
[TD="class: xl65, align: right"]3[/TD]

[TD="class: xl65"]d[/TD]
[TD="class: xl65, align: right"]3[/TD]

[TD="class: xl65"]c[/TD]
[TD="class: xl65, align: right"]4[/TD]

[TD="class: xl65"]e[/TD]
[TD="class: xl66, align: right"]6[/TD]

[TD="class: xl65"]f[/TD]
[TD="class: xl65, align: right"]5[/TD]

[TD="class: xl65"]f[/TD]
[TD="class: xl65, align: right"]5[/TD]

[TD="class: xl65"]e[/TD]
[TD="class: xl66, align: right"]6[/TD]

[TD="class: xl65"]e[/TD]
[TD="class: xl66, align: right"]7[/TD]

[TD="class: xl65"]e[/TD]
[TD="class: xl66, align: right"]7[/TD]

[TD="class: xl65"]e[/TD]
[TD="class: xl66, align: right"]8[/TD]

[TD="class: xl65"]e[/TD]
[TD="class: xl66, align: right"]8[/TD]

</tbody>