get cell value from one sheet to another based on ID column
I have three grid sheets A,B,C
in sheet, A I have two columns as follows:
in sheet B& C, I have the same two columns.
I want sheet B to get the status value if the status changes in C
Also, I want sheet A to get the status value if the status changes in B
is it possible to achieve this using Vlookup or any other method?
Please note that I tried using automation to copy records if the status changes, but that will create a new row in my sheet. I don't want duplicates ID. I just need to update the status of the sheets whenever there is a change made based on the ID column
Kindly advise. Thank you!
Answers
-
So would sheet C be your source of truth that updates both Sheets A and B?
-
You would use an INDEX/MATCH formula like so:
=INDEX({Sheet C Status Column}, MATCH(ID@row, {Sheet C ID Column}, 0))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
not exactly, sheet A will check if sheet C contain a status value based on the ID number if it is null
it will check for sheet B and return its value.
-
Thank you a lot!
I just want to know if there is a way for sheet A status column to be updated if sheet C contains a value in the status column, if not it will check with sheet B and return its value
-
Try this:
=IFERROR(INDEX({Sheet C Status Column}, MATCH(ID@row, {Sheet C ID Column}, 0)), INDEX({Sheet B Status Column}, MATCH(ID@row, {Sheet B ID Column}, 0)))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives