Move on the next excel sheet if value or match not found

excel

#1

Dear All,

I have 2 excel Files, one File has payment date and transaction of the customer who has done double payment. second File 2 has 12 different sheets of all month payments details.

I want to search the transaction from the File 1 , in All the sheets of file 2.

what want to achieve is - if transaction number is available then pick the Date , if not then go to next sheet using same Data_table and search for same transaction, so on.

Please help

Regards,
Hitesh