Can anyone help me with the following? This is a little tricky so please let me know if you know how to figure this out.
I have two data tables (both come from SharePoint sites) when I pull the two data tables I want to compare one column from DT1 with another column in DT2. If a ‘name’ or ‘code’ exists in both data tables in the same column, I then want to update DT1 to include an extra column with value ‘Yes’ for the row in DT1. Does that make sense? I know this is difficult so would be very grateful for any help
If you have the same values in both the excels, you need to update the column as yes as per my understanding, so you just need a VLookup to do that @Bob2