i have 1 dropdown and 2 textbox. i want to lookup ColumnB and ColumnC in a 2 single line textbox after i selected the ColumnA.

example:

if i select Jake in a dropdown list, the Department column must automatically lookup "Admin" and the Position column must lookup "IT"

is that possible for zoho creator?