How to look up and select data from another sheet

Options

I've a form created from 'Sheet A' , and want the 'Client Company' field to look up 'Sheet B', and allow me to select a record from it (Sheet B). Example shown in screenshot below. Is this possible, and how can I accomplish this? Thanks in advance.


Answers