How to link a dropdown list to specific phrases?

Ask Question

Asked 3 months ago

Modified 3 months ago

Viewed 15 times

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

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 ?

user311306

asked Aug 23 at 3:09

Jim

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

Add a comment |

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

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.