How do I return a value from a column based on 2 other columns

[Ethan1212]

Hello, I am currently trying to create a new column with the serving distance by matching the Vendor IDs from the two sheets.

I have a vendor ID in each and want to match those values in order to return the serving distance from the "Vendors" sheet to the corresponding row in the "Customers" sheet.

I can't do it manually because there are about a hundred thousand customers and I can't seem to figure out how to do so.

Thanks!

[AliGW]

Welcome to the forum.

2101 is MS365 - this is what needs to be in your profile, please.

[MarvinP]

Hi Ethan and welcome to the forum,

It looks like:

Please Login or Register  to view this content.

does what you want.
See it in the attached workbook. Vlookup from another sheet.xlsx

[Ethan1212]

That worked!

Thank you so much!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.