I have a database where an employee has three or more dependents, when I make a PROCV
to pull one dependent at a time, only the first and last one appears.
=PROCV(B35;'SÓCIOS COOP'!C:G;5;1)
How do I select the first in a column the second in another column and so on?
EXAMPLE
I have these values in the database:
216 WILLIAN Filho BRUNO
216 WILLIAN Filho LUIS
216 WILLIAN Filho YASMIN
I made a PROCV in another worksheet to leave a parent and in other columns the children, I was able to pull through PROCV the first child and the last one. But I can not pull the middle child.
216 WILLIAN Filho BRUNO Filho YASMIN