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

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…