With the help of this extension you can check the VAT no is valid or not.
VAT number is checked through VAT Information Exchange System (VIES) EU VAT number database.
VAT validation can be set for any particular customer group.
VAT field can set optional or compulsary.
VAT number validation is also available when creating a new customer in the backend Admin section.
VIES EU VAT number validation