Hello - Would anyone know the best way to do the following?
I have a datatable which pulls data from the SharePoint site. I also have and excel workbook that I download. I want to compare the data table with the workbook and if ‘REF’ match in both data table and excel I want to update the datatable with the ‘Client_Name’ in the in excel. So I think I would need to add another column to the data table (which I’ve done) but I’m not sure how to compare both and then take the ‘Client Name’ from the row that matches and put that into the data table.
This is what the data table looks like when printed to a csv
This is what the excel looks like