Data entry / research

I have a spreadsheet containing approximately 2200 names of financial services businesses. Each firm (an "account") is registered with the Financial Conduct Authority (FCA) and has a unique FCA reference number. This number can be found by entering the firm's name here: https://register.fca.org.uk/.

I need the FCA reference number for each firm listed in the spreadsheet. It is important that this info is accurate and there will often be two or three entries for each firm...including historic info.

The information required is the 'Firm' number (NOT 'Consumer Credit Firm' number or anything else) and the 'Status' must be Authorised OR 'Appointed Representative'.

See the spreadsheet examples I have completed correctly in the attached a small sample of the data. If you have any questions, let me know.