Compare values of two separate sheets and returning value
Solved/Closed
Related:
- Compare values of two separate sheets and returning value
- Beyond compare - Download - File management
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- How to compare two excel sheets - Guide
- If two cells match return value from third excel ✓ - Excel Forum
- Macro to compare two excel sheets ✓ - Excel Forum
1 response
Ok, the task you are asking is much more complex than what we can deliver. You have to start at either OLE (object linking and embedding), or a system DSN Excel driver. Neither are beginning coding projects, and would be a waste of time for us to develop for you, as the trapping of errors would be so complex for all of the different variable of your environment. I have written code like this for here, and there are always failures and such for the end user is cutting and pasting and not actually trying to learn from the examples given.
We are sorry. if you had failing code, we could help then, but as far as a turn key solution, it cannot be done. I encourage you to write some code and let us know if you get stuck!
We are sorry. if you had failing code, we could help then, but as far as a turn key solution, it cannot be done. I encourage you to write some code and let us know if you get stuck!
Mar 15, 2016 at 04:59 PM
Row 1 was the header
Formula used:
=VLOOKUP(MM!B2,DG!A:D,4FALSE)
Got it. Thanks, though.
Mar 15, 2016 at 05:11 PM