With repeated values in a range, Vlookup only shows adjacent values for the last one

[fsalina]

Guys, I'm trying to figure it out but didn't find anywhere.

There's a list of names with their respective numbers and words and three comboboxes fiiled with the names, numbers and words.

When I select a name in the "combobox for names" I want to automatically fill the "combobox for numbers" and "combobox for words" based on the respective row for the selected name.

The problem is: when I select a name, the other two comboboxes only show THE LAST respective number and word for that name I've selected.

Ex.:

Name	Number	Word
Fernando	1	g	This Fernando was selected.
Fernando	2	h
Fernando	3	i	This Fernando is shown.

What I want is: when I select a name, the other two comboboxex fill with the respective number and word for every name, even the repeated ones.

I'm attaching the example file.

[fsalina]

I've been thinking of until almost now and found a way to do this.

If you came here with same doubt, here what I did:

I've declared three variables:
srcRow = ComboBox1.ListIndex + 1
srcNumber = Range("B1").Offset(srcRow, 0).Value
srcWord = Range("C1").Offset(srcRow, 0).Value

And equaled:
ComboBox2.Value = srcNumber
ComboBox3.Value = srcWord

I'm attaching the file.

teste vlookup.xlsm