Forum Discussion
Freckled-Lili
Apr 19, 2021Copper Contributor
Duplicates in drop-down menu
I'm doing an Excel assignment for my MS Office course, and one part has you create a drop-down menu for this Customer Quick Lookup Table (Screenshot 1) that will allow the user to select one of the ...
SergeiBaklan
Apr 19, 2021Diamond Contributor
If you identify person only with last name you can do nothing with that. VLOOKUP finds first appeared last name and returns info for it. In general you may return info for the last name in the list, but that changes practically nothing.
As variant you may define bot last and first name from drop down list and VLOOKUP on it combination, or use other more reliable ID.