Formula to find an IP address from one sheet and match with another excel workbook

Hi All,

Need help. I have 2 Excel files - One file have the list of IP addresses (format xx.xx.xxx.xxx) and another sheet has all the other details in which the IP addresses are spread across different rows & columns in multiple sheets in the workbook.

I want a formula where it can scan through the entire Workbook and tell me if that IP is present in the workbook or not and give me the Worksheet name in which the IP is present.

Please help me at the earliest. I am looking at a formula only and not VB codes.

Thanks & Regards,
Siritvrs

Hi, this is manual and this is not possible to do it as I have multiple sheets with each containing columns from A to AZ and rows more than 3000. I am looking for a formula.