Suppose we have 2 columns Id
& Name
which contained in sheet1
. Now in sheet2
have dropdown for Id
& Name
which user can select and it Lookup
value for each other (select Id
from dropdown, Name
automatically filled, and vice-versa).
Is this possible? Because it sounds like circular dependency.