Trying to join one worksheet to another but the common key “UserID” has multiple entry rows in one of the worksheets. When I try to do your standard vlookup, I get “#NA” when it hits the first duplicate row and every entry thereafter…
Is there a way to simply have the duplicate row take on the value of the first successfully matched row?
Edit to add data provided by Renaudb3 in answer which I’ll delete.
Using 5.1 on Windows 10.
Please see attached, Mark.VLookUp Ex.ods