# Look up column not showing as an option **URL:** \ **Category:** Ask for Help\ **Created:** [September 23, 2020, 5:07pm UTC](https://community.glideapps.com/t/look-up-column-not-showing-as-an-option/16259 "2020-09-23T17:07:41Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [September 23, 2020, 5:07pm UTC](https://community.glideapps.com/t/look-up-column-not-showing-as-an-option/16259/1 "2020-09-23T17:07:41Z")
I have spreadsheet tabs as follows: writers (name, bio, etc.) articles (writer name, article title, etc.) On the article screen I want to show the bio of the writer, so I finally was able to create a look up column and I can see that in the data, BUT it won’t let me show it in the article, the only place I can see it as an option is in title component image, which makes zero sense to me. I read somewhere else that my relation column can’t be multiple but as soon as I make it not multiple, the bio column gets deleted, so again, it’s a loop. Help? ![Screen Shot 2020-09-23 at 7.01.05 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c6f42f7ce6664785b00391059eb4219bdd858d1b.png) ![Screen Shot 2020-09-23 at 7.01.23 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b5039d33f971135b01a83fb2f6e2f56bf1a15ee8.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [September 23, 2020, 5:37pm UTC](https://community.glideapps.com/t/look-up-column-not-showing-as-an-option/16259/2 "2020-09-23T17:37:09Z")
It needs to be from a single relation. Not a multiple relation. It won’t allow you to put multiple values in a single value component. The image component allows for arrays, like the lookup from a multiple relation because the image component is designed to switch to a carousel when set from an array. ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [September 23, 2020, 5:41pm UTC](https://community.glideapps.com/t/look-up-column-not-showing-as-an-option/16259/3 "2020-09-23T17:41:03Z")
But it won’t let me show the bio on look up unless it’s a multi relation…catch 22. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [September 23, 2020, 5:53pm UTC](https://community.glideapps.com/t/look-up-column-not-showing-as-an-option/16259/4 "2020-09-23T17:53:29Z")
Can you explain more what you mean by that? Why can’t you do a lookup to the Bio from a single relation? How are you trying to display it? ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [September 23, 2020, 6:02pm UTC](https://community.glideapps.com/t/look-up-column-not-showing-as-an-option/16259/5 "2020-09-23T18:02:02Z")
If I make it “single”, it tells me it has to delete the bio column that was created based on the multiple, see attached. ![Screen Shot 2020-09-23 at 8.01.35 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/cb413ce3da31e3cbff61d0ab83a08082a32971de.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [September 23, 2020, 6:05pm UTC](https://community.glideapps.com/t/look-up-column-not-showing-as-an-option/16259/6 "2020-09-23T18:05:34Z")
That’s fine because you are changing the relation type and any associated columns will be affected by that change. If Bio is just a lookup column and you aren’t using it for anything yet, then just let it delete and recreate it under the single relation. Changing the relation type means the lookup array is no longer possible and it now needs to be lookup type that can only hold a single value. ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [September 23, 2020, 6:09pm UTC](https://community.glideapps.com/t/look-up-column-not-showing-as-an-option/16259/7 "2020-09-23T18:09:39Z")
For whatever reason now that I did that, it worked. I tried 5-6 times before and it didn’t. Thanks for your support @Jeff_Hager 👏🏼 👏🏼 👏🏼