There is an Access table and that stores details about each batch. So I want to check each batchno in columnA to make sure if its present in Access table as well. If yes then populate corresponding Policyno from Access table to column A of the excelsheet.

Thanks