Dajah✭

I figured it out! And it works great. I used the INDEX function recommended below but apparently I can't use the same data set twice on the same sheet? When I update one, it updates the other. VLOOKUP it is. Thank you!

THIS WORKED! Thank you so much. :)

I think I'm missing something at the beginning- I'm getting a circular reference error. Maybe I copied something verbatim that should have been filled with my own info? My source data sheet is called "Price Lookup PRODUCT." Column 1 is Item and column 2 is Price. I am selecting both of these columns for the lookup_table…

Follow up question- can I set conditional formatting so that when a box is checked in a column (marking the row/ticket as Resolved) it clears the update requests that may be pending?

Thank you for the reply. If the update request is sent to all users, does that notification disappear for everyone else once someone from that department has updated the item? Essentially I'd like it to be so that once the next team member online resolves it, every subsequent team member doesn't still have the request…

I think I'm confused- you mentioned a forum post about time tracking, but the link is to submit a product enhancement request. I was wondering about the forum post? Thank you

Thanks Mike. I didn't see a link to the forum post- can you post it here? I'm wondering if there's just a better workaround for this entire process.

Thank you! Follup question: Can the lookup function reference data in another sheet? I cannot think of a way to put all the reference data on the same sheet we need the values to be populated on.