0
I have a database where an employee has three dependents or more when I do a PROCV to pull one dependent at a time, appears only the first and the last.
=PROCV(B35;'SÓCIOS COOP'!C:G;5;1)
How do I select the first in one column the second in another column and so on?
EXAMPLE
I have in the database these figures:
216 WILLIAN Filho BRUNO
216 WILLIAN Filho LUIS
216 WILLIAN Filho YASMIN
I made a PROCV in another spreadsheet to leave a father and in other columns the children, I managed to pull through the PROCV the first son and to the last. But I can’t pull the middle child.
216 WILLIAN Filho BRUNO Filho YASMIN
I suggest giving an example of the values you have and what you want to get. O
PROCVjust behind a value, and it is the column that is the third parameter, in its example the5. If you need three values do threePROCVchanging the column parameter.– Isac
Friend, the file always brings the first occurrence that you find in the indicated column.... then to do what you need you will need to use something more than a procv. Something like, sort the dependent table by employee name, count how many occurrences you have, search for the first and most occurrences found... the formulas Indice and corresp can help you there. Take a look here: http://excelguru.com.br/excel-2/indice-corresp/ - I suggest you edit your question completely... later I can publish a reply. good luck!
– Evert