get cell value from one sheet to another based on ID column

Mashael · 07/19/23

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!

Samuel Mueller · 07/19/23

So would sheet C be your source of truth that updates both Sheets A and B?

Paul Newcome · 07/19/23

You would use an INDEX/MATCH formula like so:

=INDEX({Sheet C Status Column}, MATCH(ID@row, {Sheet C ID Column}, 0))

Mashael · 07/20/23

https://community.smartsheet.com/discussion/comment/386068#Comment_386068

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.

Mashael · 07/20/23

https://community.smartsheet.com/discussion/comment/386073#Comment_386073

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

Paul Newcome · 07/20/23

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)))

get cell value from one sheet to another based on ID column

Answers

Categories