Unanswered

Compare two Excel files. Update row when multiple columns match

(0) Share

Report

Posted on by robayala1

Hi,

I am trying to compare two excel sheets and when Mutiple columns match add the owner and department to the first excel sheet. I have it partially working but I believe the problem is 'Key Column' and 'Key Value'. I don't have a unique Key Value. It's only unique when the 4 columns match. Not sure what to put there. So it's skipping when only one of the values match. Doing this through Automate rather than a Vlookup. Please Help. Thank you in advance.

Summary:

Add Department and Manager from Sheet 2 'DBOwner' to Sheet 1 'DBReport' when Database, ID, Server Instance, Environment Match. (Output shown at bottom)

Flow:

Output:

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Its not skipping when only 1 matches, your condition states they all have to match or it won't do an update.

So I am not sure what you mean?

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
RobA1 18 on at

Like (0)

Report

Thank you for responding. What I mean is when the
'Database+ID+Server/Instance+Environment' from Sheet 1
match
'Database+ID+Server/Instance+Environment' from Sheet 2

Then Add
Department+Manager from Sheet2 to Sheet 1

In the example output you can see that it left a couple rows blank where I indicated the skipping.. It did not match. So I am assuming the issue to be with the 'Key Column and Key Value;. Not sure.

Thank you.

Was this reply helpful? Yes No