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.

1 Answer 1


It is indeed a circular dependency. You can either have ID dropdown or Name dropdown and counterpart of it will need to be secured by VLOOKUP formula:

=IFERROR(VLOOKUP(A2, Sheet1!A2:B, 2, 0), )


=IFERROR(VLOOKUP(B2, {Sheet1!B2:B,Sheet1!A2:A}, 2, 0), )


demo spreadsheet

  • huh, i suppose this scenario is common since searching by Id is a hassle, and searching through Name is more convenient, but Name may contain duplicate so Id also necessary. If circular lookup isn't possible, is it possible to display more than 1 column in dropdown list?
    – Suwandy
    Mar 18, 2019 at 1:07
  • what do you mean by: more than one?
    – user0
    Mar 18, 2019 at 1:08
  • i.e. Id dropdown contains list of Id (by range selection). Is it possible to include 2nd column Name in that dropdown list? this way only 1 dropdown needed
    – Suwandy
    Mar 18, 2019 at 1:12
  • no, that's not possible. it would be if you would merge those two columns under one and then output it under a dropdown
    – user0
    Mar 18, 2019 at 1:14
  • 1
    alright, conclusion is "No". Thanks for the insight
    – Suwandy
    Mar 18, 2019 at 1:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.