Excel how to do vlookup with inconsistent names on both different sheets?

Hi Ali,

Thanks, I've googled and tried this before. But it doesn't work.

I've added wild cards both at the front and back of the table array.

=VLOOKUP($A$2:$A$602,"*"&'sheet2'!$A$217:$C$318&"*",3,FALSE)

You have chosen a range in the lookup value argument instead of a single cell and another thing is wild card character can be used within the lookup value argument instead of table array so this can be the reason you are getting an error.

Could you please share the screenshot of both of your tables (source table and the table where you want to look up the data) so I can look at the exact scenario?

(make sure to cover any private information before uploading it here as this is a public forum)

Thanks,

Ali

Hi James,

Thanks for reaching out. My name is Ali. I'm an Independent Advisor and a Microsoft user like you. I'll be happy to help you out today.

You can perform partial lookup using a wild card character which helps you to deal with the scenario. Please refer to the links below

https://www.teachexcel.com/excel-tutorial/vlook...

https://www.excel-university.com/vlookup-hack-9...

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

I hope it worked out well for you. If not, please reply back to this forum to let me know or mark this as resolved along with your feedback. :) I will be glad to follow up and help you.

Thanks,

Ali