This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
@Kartik_Borikar ignore the above comment You can use your approach but
instead of [city_id] use [_thisRow].[city_id]
LOOKUP([_thisRow].[city_id], “Sheet1”, “city_id”, “district_id”) =
LOOKUP(USEREMAIL(), “Usersloc”, “user_email1”, “district_id”)