Importing BPL Card RC Number Details Using Google Sheets 'IMPORTHTML' Function

Copy

Highlights:

If cell "A1" contains a old RC number, New RC Number is displayed.

If cell "A1" contains a Incorrect RC number, Incorrect RC Number alert message is displayed.

If cell "A1" contains a new 12-digit RC number, display the following details: Serial Number, Family Member, Aadhar Number & Status respectively.

Explanation:

     This formula uses Google Sheets "IMPORTHTML" function to import data from a website. It fetches the table data from the URL "https://new.lidkar.esy.es/bpl/view_rc.php?rcNumber=" 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 Highlighted details.

     Please make sure to insert RC number 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.