jnix612
02-06-2020, 10:27 AM
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?
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?