Populate a cell based of a match - Match/vlookup

I'm updating a form which will allow customers to select their establishment from a drop down list. When they select their establishment, I would like to auto populate some cells with their information (number of staff, reference, etc)

I'm also looking at ways to allow new customers the free text option to add their establishment to the list/form and manual enter their details - how would this work with the above? I'd need the formula to ignore an error messages and leave the cells open to freetext

Maybe have a look at this example :

Hiya - i forgot to say, these was absolutely perfect and just what i needed!

thank you

Glad to help