I have 2 lists in sheet 2, one called UNIT, the other Account.
The UNIT and their Account are on the same row.
On the form I made a drop down field to enter the Unit. It works.
I would like to have the Account for the Unit filled in the Account field on the form when the Unit is selected from the drop down menu.
How do I do this?
Please email me your answers.