Populate a cell based of a match - Match/vlookup

Is there any easy user guide to using the match/vlookup functions?

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

If you want a guide take a look at "Excellsfun" on YouTube,

To answer your questions ..

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I think it's uploaded? Just a real simple idea of what I'm looking to do