Cross Sheet Referencing Help
I have two sheets that I am trying to connect and am unsure of how to approach. I am a newbie to formulas and would love to learn what is possible!
One sheet is a content tracker where my team will track unique selection titles. This unique title will also appear in my source sheet, where a status column will be updated as it moves through an approval process. I would like for the status to update in the content tracker as it changes.
The source tracker also houses additional row data (not tracked on the content tracker sheet) that might make cell linking difficult. Additionally, due to formatting requirements in my source sheet, I am unable to setup a VLOOKUP formula, because the lookup value (text selection title) will be to the right of my returned value (status). Wondering if an INDEX/MATCH or COLLECT formula would be a better fit, but am not as familiar with how to set up. Any advice would be so appreciated!
Some screenshots that may be helpful:
Content tracker where title is populated. Status column should pull in current status from Source sheet.
Source sheet with status column to the left of the text selection column. Columns must remain in this order. Status values update via a dropdown menu.
Best Answer
-
I will check it and come back to you ASAP
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Hi @Karen_Pytel
Hope you are fine, yes you can use Index With Collect for that. if you like to fix the formula directly on your sheet please share me as an admin on a copy of your sheets ( Source & Destination ) and i will Create the exact formula for you then you can copy it to your original sheet.
My Email for sharing : Bassam.k@mobilproject.it
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Thank you @Bassam Khalil! Appreciate your help!
-
I will check it and come back to you ASAP
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Thank you for the help @Bassam Khalil. Much appreciated!
-
You are welcome and I will be happy to help you any time.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!