# Import Range User Defined Variable

**URL:** <https://community.glideapps.com/t/import-range-user-defined-variable/25935>\
**Category:** Ask for Help\
**Created:** [April 23, 2021, 7:15am UTC](https://community.glideapps.com/t/import-range-user-defined-variable/25935 "2021-04-23T07:15:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andrew\_Gilmour](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_gilmour/32/24588_2.png) [@Andrew\_Gilmour](https://community.glideapps.com/u/Andrew_Gilmour)\
**Post date:** [April 23, 2021, 7:15am UTC](https://community.glideapps.com/t/import-range-user-defined-variable/25935/1 "2021-04-23T07:15:10Z")

</div>

I have a list of courses that I want to display in a choice field. I have this working fine.

I then want to create an IMPORTRANGE from a sheet that holds information about the selected course.

Is there a way to run the IMPORTRANGE based on an individual user-specific selection in the Course choice field?

If I don’t have a user-specific selection then two members of staff will not be able to look up course details simultaneously.

Thanks

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 23, 2021, 7:33am UTC](https://community.glideapps.com/t/import-range-user-defined-variable/25935/2 "2021-04-23T07:33:24Z")

</div>

Is there a reason why you don’t have the course information in the same sheet you’re using?

Let’s say I choose course A, then I should only see info about course A, is that the flow you’re having?

---

<div class="post-metadata">

**Author:** ![Andrew\_Gilmour](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_gilmour/32/24588_2.png) [@Andrew\_Gilmour](https://community.glideapps.com/u/Andrew_Gilmour)\
**Post date:** [April 23, 2021, 7:50am UTC](https://community.glideapps.com/t/import-range-user-defined-variable/25935/3 "2021-04-23T07:50:09Z")

</div>

It is in the same sheet - I just created the second sheet to get the UNIQUE course names and course ID.
