I'm creating a dropdown list of names that are matching to the company. For example, this is the list:

Name Company
Name Corresponding
Macfee-John Macfee
Macfee- Jane Macfee
Aventis- Doe Aventis
... ...

My plan is when I select the name from the dropdown list (E.g. Macfee-John), it will produce the Company name in the next coloumn.

Currently I have manually written a list of all the names and the company and used:

=IFERROR(INDEX($Y$2:$Y$N, MATCH(C2, $X$2:$X$N, 0)), "")

But, it keeps returning me a circular dependency error.

Does anyone know why this happens and what I can do to fix it ?

  • What do $X$N and $Y$N mean? $XN and $YN? Something else?
    – Blindspots
    Aug 24 at 3:00
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Aug 24 at 3:01


Your Answer

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

Browse other questions tagged or ask your own question.