VLookup Duplicating Data

[jnix612]

I have a column of names of travelers. They travel several times a year and each row of details are always different. I set VLookup to show me 2 dates for the traveler: Travel date and Date expense submitted. I am calculating how many days it takes each traveler to submit travel on a different sheet.

This is Jane Doe travel #1 row

=VLOOKUP(FY19TravBud!A13,FY19TravBud,7,FALSE)
=VLOOKUP(FY19TravBud!A13,FY19TravBud,9,FALSE)

This is Jane Doe travel #2 row This formula is giving me the data of the above formula.

=VLOOKUP(FY19TravBud!A17,FY19TravBud,7,FALSE)
=VLOOKUP(FY19TravBud!A17,FY19TravBud,9,FALSE)

In each instance a traveler's name is duplicated, Excel populates the data of the first instance the name appears. I have one guy with 4 entries and all the data is the same as the first entry of his name.

What am I missing?

[Paul_Hossler]

What am I missing?

Nothing, that's the way VLookup() works

Maybe you can get Filter or Advanced Filter to do what you want

[jnix612]

OHHH! Darn. OK thank you. I will look at your suggestion.