Why is vlookup returning wrong values

Core Formula. Email HP. I absolutely LUV your explanations and examples! You have saved me a lot of time and frustration. Thank you, thank you, thank you. Excel video training Quick, clean, and to the point.

I recommend making this a specific range rather than referring to the entire columns. It will use less resources and help the link update faster. Products 75 Special Topics 42 Video Hub Most Active Hubs Microsoft Teams.

Security, Compliance and Identity. Microsoft Edge Insider. Azure Databases. Project Bonsai. Education Sector. Microsoft Localization. Microsoft PnP. Healthcare and Life Sciences.

Internet of Things IoT. Enabling Remote Work. Small and Medium Business. It is far more versatile. The example below shows it being used to return information to the left of the column you are looking in. It will return the first record that matches the value you looked for. Should your list have duplicates? If not consider removing them. A quick way to do this is to select the table and click the Removes Duplicates button on the Data tab. Check out the AbleBits Duplicate Remover for a more complete tool for handling duplicates in your Excel tables.

Ok, so your list should have duplicates. A PivotTable would be perfect to select a value and list the results instead.