This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm trying to do mass updates using the master data add-in for Excel to update my SQL server data using the Vlookup function. After I opened my excel workbook, I connected to my SQL server and downloaded my data, from there I filtered down on a series of data I want to update and copy and pasted it into another tab of the workbook. In order to Publish my changes, I need to upload my data through the master data add-in. I would like to be able to do a vlookup from my master data to my second data tab, then copy/paste my updates without overwriting other rows of data that are not being updated.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Hi Angela0426,
For this issue, I’ll suggest you create a new thread in SQL Server Master Data Services forum to get the expert assistance, this forum mainly focus on the issues related to SQL server.
Here is an article about vlookup function, see if this helps:
Thanks for your understanding.
Regards,
Jerry