1

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.

0

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), )

0

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

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 at 1:07
  • what do you mean by: more than one? – user0 Mar 18 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 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 at 1:14
  • 1
    alright, conclusion is "No". Thanks for the insight – Suwandy Mar 18 at 1:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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