Forum Discussion
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 ...
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.