If you are a Google Sheets user and deal with financial activities frequently, this formula uses Google Sheets "IMPORTHTML" function to import data from a website. It fetches the table data from the URL "http://lidkar.esy.es/bankifsc/bank.php?ifsc=" concatenated with the value in cell "A1". The second argument "table" specifies that we want to import data from a table, and the third argument "1" indicates that we want to import data from the first table on the page. The formula imports Bank Name, Branch & Address respectively.
Please make sure to add IFSC code in cell "A1" or replace "A1" with the appropriate cell reference if you intend to use it with a different cell.
Kindly note: Currently Microsoft Excel doesn't support the "IMPORTHTML" function. Alternatively, you can use VBA (Visual Basic for Applications) macros in Excel to achieve the same.
For any support, please feel free to drop me an email.
