Auto populate data in Forms
I am trying to auto populate the data in Forms for example if we select ID the corresponding fields will get auto populated with required values.
As per the attachment if we enter any ID in the CUS ID field it should populate the PSS First Name, Last Name, email and Manager email.
I tried to do this by cross sheet Vlookup function in main spreadsheet but it didnt worked for me.
Can anyone suggest me how to fix this.