# Fomula Help please

**URL:** <https://community.glideapps.com/t/fomula-help-please/56539>\
**Category:** Ask for Help\
**Created:** [January 10, 2023, 3:51pm UTC](https://community.glideapps.com/t/fomula-help-please/56539 "2023-01-10T15:51:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kristine\_Cadangan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kristine_cadangan/32/52673_2.png) [@Kristine\_Cadangan](https://community.glideapps.com/u/Kristine_Cadangan)\
**Post date:** [January 10, 2023, 3:51pm UTC](https://community.glideapps.com/t/fomula-help-please/56539/1 "2023-01-10T15:51:56Z")

</div>

Hello, reaching out to ask help on what formula can I use to pull the number for a certain category that is in a dropdown list in the spreadsheet?

Or do I need to create a separate column for each category that I want to show in a graph in the app?

Thank you!

---

<div class="post-metadata">

**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:** [January 10, 2023, 4:05pm UTC](https://community.glideapps.com/t/fomula-help-please/56539/2 "2023-01-10T16:05:05Z")

</div>

Would probably need to see screenshots to have a better understanding, but if you have a table that lists each category in one column, and it’s associated number in another column, then you can create a relation and lookup column to retrieve that number.

Or another solution could be to use an IF column to return the correct number for each category.