# How can i get the last value from Lookup Column

**URL:** <https://community.glideapps.com/t/how-can-i-get-the-last-value-from-lookup-column/42006>\
**Category:** Ask for Help\
**Created:** [May 16, 2022, 10:09am UTC](https://community.glideapps.com/t/how-can-i-get-the-last-value-from-lookup-column/42006 "2022-05-16T10:09:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\
**Post date:** [May 16, 2022, 10:09am UTC](https://community.glideapps.com/t/how-can-i-get-the-last-value-from-lookup-column/42006/1 "2022-05-16T10:09:28Z")

</div>

As per the below photo, i have a lookup column contains values.  
How can i get the last value for every row.  
 ![Rev No Glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/3/c3211afd4dc0a0512272a72b35b6ff497b05bb5f.jpeg).

As far as i know, i could pull that data by using a single value column, However, i need this to be continues and automatic for each row individually.

Kindly, How can i do that?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [May 16, 2022, 10:18am UTC](https://community.glideapps.com/t/how-can-i-get-the-last-value-from-lookup-column/42006/2 "2022-05-16T10:18:43Z")

</div>

Single Value should do it.  
Make sure you are targeting the Lookup column directly, and not via the table name.

---

<div class="post-metadata">

**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\
**Post date:** [May 16, 2022, 10:32am UTC](https://community.glideapps.com/t/how-can-i-get-the-last-value-from-lookup-column/42006/3 "2022-05-16T10:32:50Z")

</div>

Exactly, Thank you for this note. i got it.

Rally Thank you

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [May 17, 2022, 10:33am UTC](https://community.glideapps.com/t/how-can-i-get-the-last-value-from-lookup-column/42006/4 "2022-05-17T10:33:43Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.