Populate Word Drop-down list with Excel column then auto fill form fields with Excel data

[Faldinio]

Hi,

I need to auto populate a drop down list with Excel data for example, Column A in 'data.xlsx'. Which I have managed to do by searching the forum and finding a macro to do it.



I now need other form fields to populate based on the selection in the drop down list.

I am not an expert in Word as my experience is based more in Excel.
I basically need the Word template to do a VLOOKUP based on what the user selects in the first drop down box, then populate about 5 other fields automatically.

Any help would be much appreciated. If giving advice, please remember that I'm not an expert in Word so may need more detailed instructions!

Mark