Match or VLookup?

I cannot figure out how to cross reference two excel documents for changes made from one day to the next. Long story short, our EDI process is not working at this time. Until it is up & running, our csr is required to manually review each page for changes from the previous day. It is so time consuming but until EDI is up & running, this is the process.

Also, is it best to use VLookup or Match to find the differences between the documents? Any help would be greatly appreciated! Thank you!!

Find more posts tagged with

Manufacturing

Formulas

Support

IT & Operations

Importing and Exporting

Comments

Shaine Greenwood

Hello—

It appears that you've posted this to the wrong forum. This is the Smartsheet community, where people help one another with solutions that involve the Smartsheet application.

If you're looking for assistance with an excel process, I'd recommend posting your question on an Excel forum. Here's one of Microsoft's forums for Excel: https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat

Otherwise, if your process also involves Smartsheet, please reply and clarify how Smartsheet fits into the picture and we can assist.

lisarae723

Hi Shaine,

My apologies, it seems I didn't explain properly. I want to use Smartsheet as an alternative to manually reviewing purchase orders & forecasts, for changes or additions made from the previous day. It's extremely time consuming for our csr. I would think I could load them to smartsheet to do the comparisons.

Im not sure how to set this up. Would I use Vlookup, or is this something Datamesh would be used for? Any ideas or suggestions, help would be appreciated. Thank you!

Andrée Starå

Hi Lisa,

Would it work for you to move the process entirely to Smartsheet or you have to use the Excel files? How large are the files (rows, columns, cells). Can you share one file or some screenshots?

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Shaine Greenwood

No worries, I think I understand you now.

VLOOKUP and Datamesh will both work in Smartsheet. My recommendation is to explore using VLOOKUP or a combination of the MATCH and INDEX functions. Typically, you can create those formulas in your sheet and get your expected result without having to invest in Datamesh. (Datamesh is a paid premium add on.)

What CSR are you using? We might have an integration that can sync the data between your CSR and Smartsheet: https://www.smartsheet.com/partners

More on our formulas can be found here: https://help.smartsheet.com/functions

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.