Data validation and lookup

[Sales_Shantikru]

I m creating an app for shop floor maintenance activity.

a new complaint is to be raised, by submitting form.

During form submission, I need 2 dropdown list of names 1. Complaint raised 2. Responsible person.

I Created separate table for data validation
Tried with validif function but it allots second name by default which is in the row of first name. I need two independent dropdowns

Also, after names, I have email and phone, which I want to be fetched automatically once name is chosen from dropdown. This is simply not happening with lookup().

Lookup ((complaint raiser), “validif_ref”, “complaintraiser”, “Email”)

Thank you in advance
Regards,
Sarang