Hi,
We have a requirement where we need to compare two lists in sharePoint. Currently we do that after taking extracts and doing vlookup. 
Is it possible for us to automate that in SharePoint ( out of the box only without using visual studio )

Please advice. 

Many thanks.

Regards,

prajK

Hi,

According to your description, my understanding is that you want to compare two list in SharePoint.

Per my knowledge, there is no OOTB feature in SharePoint.

If you want to automatically compare the list, I suggest you can try to use Server Object Model to export the list to excel and then you can use some VBA code to vlookup two exported list to compare them.

Here are some detailed articles for your reference:

Export SharePoint list to Excel Programmatically using c#- SPListItemCollection.GetDataTable method

Vlookup VBA 

Thanks

Best Regards